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