ExcelBanter - DSum Criterion

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - DSum Criterion (https://www.excelbanter.com/excel-programming/416251-dsum-criterion.html)

I 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).

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!

"Sue" wrote:

I 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).