DSUM AND Condition

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.
 
R

Ron Coderre

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)
 
T

ToferKing

Thanks, Ron.

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

Thanks for your help.

Tofer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top