Hi,

I have for eg. 3 columns.... group 1(A), group 2(B), total group(C).
for each row column C has formula A1+A2.

At the bottom of column C I have the count function (which tells me how many
I have had returned.)

My problem is because every row for column C has the sum formula. It gives
me a 0.00 entry even when there is nothing in column A or B, it gives me an
inaccurate count.

How Do I make my sum formula give me an empty entry until I put either a
0.00 or any other amount.????