SUMIF


G

Guest

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

Advertisements

T

Tom Ogilvy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top