Excel Video: Using Excel Database DSUM Function
Excel Video: Using Excel Database DSUM Function
The Excel DSUM function returns the sum of values from a set of records that match criteria.
The values to sum are extracted from a given field in the database.
Purpose
Get sum from matching records
Return value
The calculated sum
Syntax
=DSUM (database, field, criteria)
Arguments
database - Database range including headers.
field - Field name or index to count.
criteria - Criteria range including headers.
Usage notes
The Excel DSUM function calculates a sum of values in a set of records that match criteria.
The values to sum are extracted from a given field in the database, specified as an argument.
The database argument is a range of cells that includes field headers, field is the name or index of the field to query, and criteria is a range of cells with headers that match those in database.
Field can be specified with a name or index.
Watch the example in the video to learn more
Is the video helpful?
Drop you comment and reshare
Have you subscribe to my YouTube channel?
You are missing a lot on Excel
Смотрите видео Excel Video: Using Excel Database DSUM Function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Akerele Oluwasogo (Mr Excel) 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 43 раз и оно понравилось 0 людям.