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