Dsum not recognizing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
Ken said:
I'm using a DSum function to total data with similar criteria. I have set
Click to expand...
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.
 
sumproduct((left(a2:a200),2)=10)*c2:c200)
should be
sumproduct((left(a2:a200),2)="10")*c2:c200)
 
Back
Top