Summing Columns

Hi Graham,

Thank you for your question.

You can use the DSUM function to achieve this.

The first thing to do is copy the column headings of the ranges you are trying to sum to some blank cells.

Underneath the relevant column heading type <>#N/A. This is saying not equal to #N/A.

There are three arguments:

1. Database range, so all the cells in the column you are trying to sum including the heading.

2.Field argument is the cell that contains the column heading at the top of the data figures you are trying to sum.

3. The final argument is the criteria which is the copied heading and the criteria you typed underneath it.

I hope this answers your question.

Regards

Simon