sumif question


G

Guest

I would like to do a sumif and have logical statement to
filter sum values out.


Example:

A Column B Column
S4 1
S5 2
S2 3
S1 100

Sumif(a 1 to 4, <>"s4",<>"s5","<>"S2", b 1 to 4)
= 100.
How do I are the expression to only add the "S1"?
 
Ad

Advertisements

T

Tom Ogilvy

Well, yours was a little bit different: (but conceptually the same) <g>

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

Advertisements

G

Guest

Thanks Tom's Solutions worked fine.
Thank you
-----Original Message-----
Hi Tom
and probably he hasn't responded :-(
So a waste of time on my side...

--
Regards
Frank Kabel
Frankfurt, Germany



.
 
Ad

Advertisements


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

sumif question 2 4
SUMIF 1
Group and SUM 4
How doable Using Excel? 2
Union, intersection, join 1
Calculating formula ..circular references 1
2 sheets and a select 2
Help 3

Top