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

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

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

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

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

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