Hey guys,

I have to perform a DSUM function that has an AND condition in it in the
Criteria portion.

When I set up the DSUM function without the condition as below, I get an
answer (but it isn't right).

=DSUM(Sheet2!$A$1:$J$1561,"RevisedEstimatedAmt",F2 1:F22)

I need the formula adjusted to include the criteria that F21 is F22, G21 is
G22 and H21 is H22 as well

When I adjust the formula to look like this, I get the error #VALUE

=DSUM(Sheet2!$A$1:$J$1561,"RevisedEstimatedAmt",AN D(F21:F22,G21:G22,H21:H22))

How do I get DSUM to accept three criteria?

Thanks as always, Tofer.