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?

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?