Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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.? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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.? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |