DSum not recognising criteria correctly

S

Sue

I am using Excel 2000 and have the following formula in a cell:
=DSUM(CRData,7,acd)
Unfortunately to get the right answer I have to put:
=DSUM(CRData,7,acd)-DSUM(CRData,7,acdiv)

Why does Excel sum all the “div†values into the total of “d†values so that
to get the true “d†total uou have to subtract the “div†(or any other 3
letter group beginning with d). I have tried these formulae in Lotus and
there is no problem.
 
S

Sue

The answer to this is that the default is "anything starting with" what is in
the criterion. To get an exact match (as required here) the second line of
the criterion needs to be ="=d" which displays as =d. The "right" answer is
then obtained. It makes me think about all criteria I have!
 

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 Criterion 1
Dsum and Dmax with structured references 1
Dsum with multiple Criteria not working 0
Dynamic DSUM? 1
dsum sytax error 5
DSUM Date Criteria 3
Sums from two criteria 4
Dsum Problem with date criteria 1

Top