Jonathan has attended:
Project Intro Intermediate course
Project Advanced course
Excel Advanced course
DSUM
How do I use the DSUM function
RE: DSUM
Hi Jonathan,
Thank you for your question.
There are three arguments:
1. Database (range of cells that make up your data list including headings).
2. Field (Which field do you want to sum).
- Can be a column index number or the name of the column heading in speech marks.
3.Criteria range - This area consists of headings which are copied from the main list and pasted somewhere else on the sheet. Type the criteria required under each of the copied headings.
e.g. dsum(a1:h41,"Salary",L1:P3)
I hope this answers your question.
Regards
Simon