sumif function
 

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

sumif function
 

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

sumif function
 

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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=535244