Hi,
I have notice something strange with the Dsum function
it is not comparing the full criteria but only the begining of it

for example:

name grade
a 1
b 2
c 3
d 4
abcd 5


criteria

name grade
a


dsum will give 6 (1 for "a "+ 5 for "abcd") and not the expect 1 for "a" only

is there a way around that?

Many thanks
Dan

Try changing your criteria to a formula:
="=a"

or use a different formula:
=sumif(a:a,"A",b:b)



Dan wrote:
>
> Hi,
> I have notice something strange with the Dsum function
> it is not comparing the full criteria but only the begining of it
>
> for example:
>
> name grade
> a 1
> b 2
> c 3
> d 4
> abcd 5
>
> criteria
>
> name grade
> a
>
> dsum will give 6 (1 for "a "+ 5 for "abcd") and not the expect 1 for "a" only
>
> is there a way around that?
>
> Many thanks
> Dan

--

Dave Peterson