Is zero not a permitted value in A or B?
--
David Biddulph

"Ron@Buy" wrote in message
...
Max
I'm a relatively new boy to Excel and eager to learn. I'm curious why
would
you use the formulas you quote rather than something that maybe I would
have
used in C1:
=IF(OR(A1=0,B1=0),"",A1+B1)
and in C10:
=COUNT(C1:C9)

Thanks



"Max" wrote:

Use this in C1: =IF(COUNT(A1:B1)=1,SUM(A1:B1),"")
Copy C1 down to C9 (say). This populates col C once you have a number
entered in either col A/B or both. Otherwise, it returns blank: ""

Then you could place in C10: =SUMPRODUCT(--(C1:C9<""))
to count the number of populated lines
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Redsphynx" wrote:
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.????