=IF(SUM(........

[Connie]

This worksheet is going to drive me around the bend!
Anyway, please someone, what is wrong with this formula?

=IF(SUM(J5+J12)=0,"",SUM(J5+J12))

Is it because I have to sum a range and not two separate
cells?

Connie

 

[Frank Kabel]

Hi
what does exactly not work?

 

[Connie]

I get #VALUE! for the answer. J5 and J12 have IF formulas
in them, but they are blank because there are no figures
for that month, so those formulas are working okay.

Connie

 

[Frank Kabel]

Hi
try:
=IF(SUM(J5,J12)=0,"",SUM(J5,J12))

 

[Ken]

Connie, it works okay for me. If the formula is in cell A1
and if J5 = 5 and J12 = -5, I get a null (blank) result in
A1. If J5 = 5 and J12 = 6, I get 11 in A1.

 

[Dave Peterson]

Try:

=IF(SUM(J5,J12)=0,"",SUM(J5,J12))

This worksheet is going to drive me around the bend!
Anyway, please someone, what is wrong with this formula?

=IF(SUM(J5+J12)=0,"",SUM(J5+J12))

Is it because I have to sum a range and not two separate
cells?

Connie

 

[Connie]

That works! And so simple! You've come to my help
again! Thank you! Connie

 

[Jack Schitt]

Possibly not what you are looking for, but you might use
=SUM(J5,J12)
and format it so that a zero value returned is hidden (third field in the
custom number format options separated by ";").

 

[Connie]

Thank you. This is what Frank came back with too, and it
works. Thank you for taking the time to answer. This
newsgroup is an invaluable tool! Connie

 

[Connie]

Yes, Frank came back with the answer too to put J5,J12
instead of J5+J12, and just with that change alone the
formula works great. Thanks for taking the time to
answer. Connie