Question: how does dsum work in excel?
Answer: Summary. The Excel DSUM function returns the sum of values from a set of records that match criteria. ... 
Get sum from matching records.
The calculated sum.
=DSUM (database, field, criteria)
database - Database range including headers. field - Field name or index to count.