DCOUNT vs. SUMPRODUCT

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I'm reviewing a workbook that has DCOUNT all through it in places where I'd
probably use SUMPRODUCT. Is there some guidance where to use one over the
other. Was DCOUNT available before SUMPRODUCT?

Thanks,
Barb Reinhardt
 
The way I see it is that multiplication is another form of additon (which is
an extended form of counting)...

to get 3x5 you can add 5 three times...

Same applies to DCOUNT/DSUM and SUMPRODUCT... with the former you can only
count/sum... with the latter you can cound/sum AND multiply...
 

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

Discontinuous conditional formats 2
Adding worksheets using sumproduct function gives error 14
Can SUMPRODUCT include an *? 2
Dcount returning no results!!! 0
Use of DSum, DCount, DLookup, etc in form after splitting 3
Workbooks Disappearing 2
Help with DCOUNT syntax 2
workbook opening takes 2 minutes 5

Back
Top