These FAQs cover 3 common DSUM topics: errors, unexpected results, and batch use in multiple cells.
FAQ
What should I do if DSUM returns an error value?
- Check whether the database range, field, and criteria range are all entered completely.
- Confirm that the field title exactly matches the column title in the data table.
- Check whether the criteria range includes the correct header row and condition values.
- Review the parameter separators and cell reference format.
Why does the DSUM result not match what I expected?
- Check whether the criteria range points to the correct cell range.
- Confirm that the field being summed contains numeric values instead of text.
- Review the data table row by row to confirm that the criteria match the intended records.
- If needed, test with a simple condition first and then add more complex conditions step by step.
How do I use DSUM in multiple cells?
- Enter the DSUM formula in the first target cell.
- Select that cell and move the pointer to the fill handle in the lower-right corner.
- Drag the fill handle down or across to copy the formula to other cells.
- Check whether relative and absolute references behave as expected, and use $ when you need to lock a range.
Glossary
| Term | Definition |
|---|---|
| DSUM | A database sum function that adds values in a specified field based on conditions. |
| Field | The column name in the database range that tells DSUM which column to sum. |
| Criteria range | A cell range used to define filter conditions, usually including a header row and condition values. |