Sum function and Dsum function

Google says it far better than I could...

The SUM function is a basic and widely used function for adding up numbers in a range.
It calculates the total sum of a specified range of cells without any conditions.
You provide a range of cells, and it simply adds up all the values within that range.

The DSUM function is more powerful and flexible.
It stands for “Database SUM” and allows you to sum fields (columns) of records in a list or database based on specific criteria.

Here’s how it distinguishes itself from its relatives:
SUM: Broadly adds all numbers in a range.
SUMIF: Allows single-condition summation.
DSUM: The master artist, capable of handling multiple complex criteria with ease.

In summary, while SUM is straightforward, DSUM is the go-to choice when you need to perform conditional summations with more sophistication and precision12. If you have

DSUM is illustrated here:

https://bettersolutions.com/excel/fu...m-function.htm