sumif function

[John Smith]

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.?

 

[Bernard Liengme]

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 >>

 

[daddylonglegs]

If your criteria don't all begin with "S" you can use a formula like

=SUM(SUMIF(A1:A6,{"sp","ab","xy"},B1:B6)