Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif help
I have a simple sumif formula which I can't get to sum. My current formula is
=SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x in it; if it does I want to add the values in cells F3 and G3. Now all this formula does is check for the x in M3 and puts the F3 value in the cell. It doesn't add F3 and G3. Jim |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif help
One way:
=(M3="x")*(F3+G3) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jim" wrote in message ... I have a simple sumif formula which I can't get to sum. My current formula is =SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x in it; if it does I want to add the values in cells F3 and G3. Now all this formula does is check for the x in M3 and puts the F3 value in the cell. It doesn't add F3 and G3. Jim |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif help
Thanks that worked!
"RagDyer" wrote: One way: =(M3="x")*(F3+G3) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jim" wrote in message ... I have a simple sumif formula which I can't get to sum. My current formula is =SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x in it; if it does I want to add the values in cells F3 and G3. Now all this formula does is check for the x in M3 and puts the F3 value in the cell. It doesn't add F3 and G3. Jim |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif help
More straightforward:
=IF(M3="x",SUM(F3:G3),0) "Jim" wrote: I have a simple sumif formula which I can't get to sum. My current formula is =SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x in it; if it does I want to add the values in cells F3 and G3. Now all this formula does is check for the x in M3 and puts the F3 value in the cell. It doesn't add F3 and G3. Jim |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif help
Appreciate the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Jim" wrote in message ... Thanks that worked! "RagDyer" wrote: One way: =(M3="x")*(F3+G3) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jim" wrote in message ... I have a simple sumif formula which I can't get to sum. My current formula is =SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x in it; if it does I want to add the values in cells F3 and G3. Now all this formula does is check for the x in M3 and puts the F3 value in the cell. It doesn't add F3 and G3. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Sumif / Sum and if??? | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |