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