Using DSUM w/multiple criteria?

[cstimart]

Is it possible to use the DSUM function w/multiple criteria? I have an existing formula...

=DSUM(Sheet1!A:G,Sheet1!D1,$B$7:$B$8)

...but I want to add another criteria, so I tried this (w/o success)

=DSUM(Sheet1!A:G,AND(Sheet1!D1,B7:B8,Sheet1!E1,A7:A8))

Any ideas?

 

[Andrew Poulsom]

You need to expand your criteria range so that it contains all the criteria. See the examples here:

http://office.microsoft.com/en-us/excel-help/dsum-HP005209069.aspx