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.

Try looking up DSUM in Excel Help and studying the examples. I think you'll
spot one that will point you in the right direction.

If not....post back with more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)



"ToferKing" wrote in message
...
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.

Thanks, Ron.

I studied the example more closely and you were right, I figured it out.

Thanks for your help.

Tofer

"Ron Coderre" wrote:

Try looking up DSUM in Excel Help and studying the examples. I think you'll
spot one that will point you in the right direction.

If not....post back with more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)



"ToferKing" wrote in message
...
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.