| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif question
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"? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumif question
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"? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumif question
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"? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumif question
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"? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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"? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumif question
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 "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"? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF Question | Excel Discussion (Misc queries) | |||
| SUMIF question | Excel Discussion (Misc queries) | |||
| Another SUMIF question | Excel Worksheet Functions | |||
| SUMIF question (I think) | Excel Worksheet Functions | |||
| SUMIF Question | Excel Discussion (Misc queries) | |||
Linear Mode
