T
ToferKing
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",F21: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",AND(F21:F22,G21:G22,H21:H22))
How do I get DSUM to accept three criteria?
Thanks as always, Tofer.
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",F21: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",AND(F21:F22,G21:G22,H21:H22))
How do I get DSUM to accept three criteria?
Thanks as always, Tofer.