I thought you said SUMIF instead of SUMPRODUCT....???? If
sumproduct,something like:
=sumproduct((a2:a22<"a")*b2:b22)
for sumif
=SUMIF(I2:K22,"<a",J2:J22)
or
=SUMIF(I2:K22,"<"&"a",J2:J22)
--
Don Guillett
SalesAid Software

"Kigol" wrote in message
ups.com...
On May 29, 2:01 pm, "Don Guillett" wrote:
"<"&"joe"
--
Don Guillett
SalesAid Software
"Kigol" wrote in message

oups.com...



Can you include NOT in a SUMIF criteria? It doesn't seem to be working
for me, any suggestions?- Hide quoted text -

- Show quoted text -

Ah yes thank you very much. A little inclusion in the sumproduct
statement and I'm good to go. Thanks guys.