The DSUM function is good for rapidly summing large sets of data with
multiple criteria. The way you described your criteria (with headings) in
A1:E2 is exactly what DSUM requires, and it's fine if the number of criteria
(A2:E2 cells with values) varies from one time to the next.

Check the Excel help for DSUM.

Hope this helps,

Hutch

"Grant Reid" wrote:

Hi Roger

Many thanks for your response. After reading my original question, I realised I had over complicated matters. What I'm actually
trying to accomplish is this..... I have data in A5:F100, I need to sum the numeric data in F5:F100 that meets criteria I have
A2:E2. Sometimes I'll need sum the data that meets all 5 criteria, sometimes I'll need to sum data that meets just one, sometimes
three etc etc

So sometimes it will look like this
A B C D E
Row 1 Year Acc Clnt Prod Rev
Row 2 xxxx xxxx xxxx xxxx xxxx

sometimes it will look like this
A B C D E
Row 1 Year Acc Clnt Prod Rev
Row 2 xxxx xxxx xxxx

sometimes like this

A B C D E
Row 1 Year Acc Clnt Prod Rev
Row 2 xxxx

etc etc. So my problem is how to sum the data in F5:F100 when the number and position of criteria vary.

Kind Regards - Grant