Try a wildcard as in =SUMIF(A1:A6,"s*",B1:B6)

Also look at SUMPRODUCT; see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

Go to source

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"John Smith" wrote in message
...
I have several SUMIF formulas in a worksheet but can only get a calculation
for a formula with only criteria like SUMIF A1:A9, "s", A2:A10. How do I
make it work if the criteria is "s" or "SP" or "sb". etc.?