sumif question
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))
--
Regards,
Tom Ogilvy
"Frank Kabel" wrote in message
...
Hi Tom
and probably he hasn't responded :-(
So a waste of time on my side...
--
Regards
Frank Kabel
Frankfurt, Germany
"Tom Ogilvy" schrieb im Newsbeitrag
...
One of the answers I gave him yesterday.
--
Regards,
Tom Ogilvy
"Frank Kabel" wrote in message
...
Hi
SUMIF(A1:A4,"S1",B1:B4)
--
Regards
Frank Kabel
Frankfurt, Germany
schrieb im Newsbeitrag
...
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"?
|