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

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

"John Smith" <[email protected]> wrote in message
news:[email protected]...
>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.?

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