One thing to try.
=sumif(trim(b4:b63),"name",i4:i63)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Michelle" wrote in message
...
Hi; I have an easy one that stumps me.
I have been using =sumif(b4:b63,"name",i4:i63) for many entries, and there
is one client name that keeps resulting in zero or nothing.
I have a monthly sales list; col b is sold to cust. name and the invoice
value is in col.i there are several entries of the same client,
so I simply,do sumif but why is this one client name resultsing in 0 ? I
have checked spelling, commas, quotes etc. his name does have an apostropy
',
but I use it in the formula.
please help
michelle