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.????

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.????

column C has formula A1+A2.
It gives me a 0.00 entry even when
there is nothing in column A or B

How does column B come into play?

Maybe something like this:

=IF(COUNTA(A1:B1)<2,"",A1+B1)

--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
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.????

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.????

Think my earlier sumproduct for the COUNT was overkill. My focus got mixed
up, vacillating between how to trap it for the row summation in col C and
what then could be used for the COUNT at the bottom. Your simpler:
=COUNT(C1:C9) would have sufficed.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"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

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.????