Dsum not recognizing data

[Ken]

I'm using a DSum function to total data with similar criteria. I have set up criteria labeled "account" and have 10* as the desired criteria, and it will not pull in data with account numbers 1020 or 1009. When I type in 1020 and 1009 directly into the criteria, the dsum function finds those values, but but I cannot get the wildcard * to work to get all values that have account number beginning with 10. Please advise.

 

[Don Guillett]

I don't use dsum cuz I like sumproduct but try 10 without the *
or
sumproduct((left(a2:a200),2)=10)*c2:c200)



--
Don Guillett
SalesAid Software
(e-mail address removed)

I'm using a DSum function to total data with similar criteria. I have set

up criteria labeled "account" and have 10* as the desired criteria, and it
will not pull in data with account numbers 1020 or 1009. When I type in
1020 and 1009 directly into the criteria, the dsum function finds those
values, but but I cannot get the wildcard * to work to get all values that
have account number beginning with 10. Please advise.

 

[Don Guillett]

sumproduct((left(a2:a200),2)=10)*c2:c200)
should be
sumproduct((left(a2:a200),2)="10")*c2:c200)