Please Help with complicated SUM formula

[mrl]

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

 

[Gaurav]

I guess...

=IF(SUM(E1,G1,J1)=0,"",SUM(E1,G1,J1))

 

[RagDyer]

Try this:

=IF(SUM(E1,G1,J1),SUM(E1,G1,J1),"")

 

[mrl]

It seems so simple seeing it here - it WORKED great. I was trying to make it
too complicated - THANK YOU so much

 

[mrl]

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...

 

[Gaurav]

Glad I could help.

It seems so simple seeing it here - it WORKED great. I was trying to make
it
too complicated - THANK YOU so much

 

[moe ghabboun]

does anyone know how to do Capital-sigma notation

?(x-n)*Y^n

from n = 1 , to n = x
assuming i have to enter x, and y







Gaurav wrote:

Re: Please Help with complicated SUM formula
01-May-08

Glad I could help.

Previous Posts In This Thread:

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

Re: Please Help with complicated SUM formula
I guess..

=IF(SUM(E1,G1,J1)=0,"",SUM(E1,G1,J1))

Re: Please Help with complicated SUM formula
Try this

=IF(SUM(E1,G1,J1),SUM(E1,G1,J1),""
--
HTH

R

--------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
--------------------------------------------------------------------------


It seems so simple seeing it here - it WORKED great.
It seems so simple seeing it here - it WORKED great. I was trying to make i
too complicated - THANK YOU so muc
-
The generosity of your knowledge is greatly appreciated

:

The formula only worked for the first cell; when I tried to auto fill, it
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

:

Re: Please Help with complicated SUM formula
Glad I could help.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating a WPF Custom Control
http://www.eggheadcafe.com/tutorial...9-c0b45fb68b78/creating-a-wpf-custom-con.aspx