Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help with complicated SUM formula
I need Excel to look at E1, G1, J1 and if the cells have a value, add those
cells across and put total in cell M1 - if no values in those cells (0% being a value), return a blank cell. I ran into trouble because E1, G1 and J1 have values returned from formula which looks at different set of cells, compares, and returns value based on argument. I came up with one that works, but it is returning a 0% value in M1 where I want it blank. So, it's not really working. I don't want 12 rows of 0% with one row of 120% in the middle, end or wherever. I hope someone can PLEASE help me - Marilyn |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help with complicated SUM formula
I guess...
=IF(SUM(E1,G1,J1)=0,"",SUM(E1,G1,J1)) "mrl" wrote in message ... I need Excel to look at E1, G1, J1 and if the cells have a value, add those cells across and put total in cell M1 - if no values in those cells (0% being a value), return a blank cell. I ran into trouble because E1, G1 and J1 have values returned from formula which looks at different set of cells, compares, and returns value based on argument. I came up with one that works, but it is returning a 0% value in M1 where I want it blank. So, it's not really working. I don't want 12 rows of 0% with one row of 120% in the middle, end or wherever. I hope someone can PLEASE help me - Marilyn |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help with complicated SUM formula
Try this:
=IF(SUM(E1,G1,J1),SUM(E1,G1,J1),"") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mrl" wrote in message ... I need Excel to look at E1, G1, J1 and if the cells have a value, add those cells across and put total in cell M1 - if no values in those cells (0% being a value), return a blank cell. I ran into trouble because E1, G1 and J1 have values returned from formula which looks at different set of cells, compares, and returns value based on argument. I came up with one that works, but it is returning a 0% value in M1 where I want it blank. So, it's not really working. I don't want 12 rows of 0% with one row of 120% in the middle, end or wherever. I hope someone can PLEASE help me - Marilyn |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help with complicated SUM formula
It seems so simple seeing it here - it WORKED great. I was trying to make it
too complicated - THANK YOU so much -- The generosity of your knowledge is greatly appreciated. "Gaurav" wrote: I guess... =IF(SUM(E1,G1,J1)=0,"",SUM(E1,G1,J1)) "mrl" wrote in message ... I need Excel to look at E1, G1, J1 and if the cells have a value, add those cells across and put total in cell M1 - if no values in those cells (0% being a value), return a blank cell. I ran into trouble because E1, G1 and J1 have values returned from formula which looks at different set of cells, compares, and returns value based on argument. I came up with one that works, but it is returning a 0% value in M1 where I want it blank. So, it's not really working. I don't want 12 rows of 0% with one row of 120% in the middle, end or wherever. I hope someone can PLEASE help me - Marilyn |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help with complicated SUM formula
The formula only worked for the first cell; when I tried to auto fill, it
would only add the last cell entered??? Perhaps it needs to be entered into each row (cell) or the cells anchored? - but the previous post's formula did the trick. Thank you for trying... I could have made this work if the previous post was not there... -- The generosity of your knowledge is greatly appreciated. "RagDyer" wrote: Try this: =IF(SUM(E1,G1,J1),SUM(E1,G1,J1),"") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mrl" wrote in message ... I need Excel to look at E1, G1, J1 and if the cells have a value, add those cells across and put total in cell M1 - if no values in those cells (0% being a value), return a blank cell. I ran into trouble because E1, G1 and J1 have values returned from formula which looks at different set of cells, compares, and returns value based on argument. I came up with one that works, but it is returning a 0% value in M1 where I want it blank. So, it's not really working. I don't want 12 rows of 0% with one row of 120% in the middle, end or wherever. I hope someone can PLEASE help me - Marilyn |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help with complicated SUM formula
Glad I could help.
"mrl" wrote in message ... It seems so simple seeing it here - it WORKED great. I was trying to make it too complicated - THANK YOU so much -- The generosity of your knowledge is greatly appreciated. "Gaurav" wrote: I guess... =IF(SUM(E1,G1,J1)=0,"",SUM(E1,G1,J1)) "mrl" wrote in message ... I need Excel to look at E1, G1, J1 and if the cells have a value, add those cells across and put total in cell M1 - if no values in those cells (0% being a value), return a blank cell. I ran into trouble because E1, G1 and J1 have values returned from formula which looks at different set of cells, compares, and returns value based on argument. I came up with one that works, but it is returning a 0% value in M1 where I want it blank. So, it's not really working. I don't want 12 rows of 0% with one row of 120% in the middle, end or wherever. I hope someone can PLEASE help me - Marilyn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated Formula | Excel Worksheet Functions | |||
Complicated formula | Excel Discussion (Misc queries) | |||
Complicated IF Formula | Excel Worksheet Functions | |||
Complicated formula | Excel Worksheet Functions | |||
Complicated Formula | Excel Discussion (Misc queries) |