DSUM

  • Thread starter Thread starter Dan Johnson
  • Start date Start date
D

Dan Johnson

Is it possible to have more than 1 criteria assigned for the DSUM function? If so, how can it be accomplished|?

Thanks, in advance, for the assistance.
 
Dan,

When you set up your criteria range, you can put many criteria, on many fields. Criteria in the same row in the criteria range are ANDed, but different rows are ORed. Thus, any row(s) that meet all criteria in the row will be included in the result. The help on DSUM gives some examples.

If you give your table layout, and what you want DSUM to do, we'll take a stab at it.
 
You must log in or register to reply here.

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

Similar Threads

DSUM with empty cell 1
Dsum Issues 0
dsum / specifiying the criteria in a constant, not in a referencearray? 4
Automatic update of the list range in DSUM 2
Dsum Help 0
dsum with multiple criteria and decimals 0
DSUM Date Criteria 3
dsum sytax error 5

Back
Top