Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF
IF I DO NOT WANT TO SUMIF LABELS S5,S4,S2
a cOL bCOL s1 100 S2 0 S4 0 S5 25 I WANT MY SUMIF TO EQUAL 100, HOW DO I WRITE THE LOGIC IN THE SUMIF FUNCTION? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF
=sumif(A:A,"S1",B:B)
If there are more than the 4 distinct labels and you want to exclude S5,S4,S2 and sum any other label =Sum(B:B)-Sum(Sumif(A:A,{"S2","S4","S5"},B:B)) -- Regards, Tom Ogilvy wrote in message ... IF I DO NOT WANT TO SUMIF LABELS S5,S4,S2 a cOL bCOL s1 100 S2 0 S4 0 S5 25 I WANT MY SUMIF TO EQUAL 100, HOW DO I WRITE THE LOGIC IN THE SUMIF FUNCTION? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF | Excel Discussion (Misc queries) | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |