=IF(ISERROR(SUM(C3:F3)),"",IF(SUM(C3:F3)<=0,"",SUM
(C3:F3)))

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi Guys:
I'm trying to combine a couple of different functions in
one formula and
can't seem to get it to work. First I want a formula
that adds a series of
cells, but I also want the cell to blank out if the sum
is zero AND I want it
to blank out if there's any type of error (such as div/0
or value/#). Here's
what I have that's working so far:

=IF(SUM(C3+D3+E3+F3)<=0,"",SUM(C3+D3+E3+F3))

and this is giving me the true sum. I also want to do
the same with the
following:

=B3-G3
=I3/K3

So, I need two things...how do I add the part to handle
errors in the first
formula above and then how do I do both for the second
and third formulas.

Let me know. I'm SO glad we have this resource...it's a
lifesaver sometimes!

Have a great weekend all!
Jessica
Virginia Beach, VA
.