Ignoring empty field in sum
 

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

Ignoring empty field in sum
 

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

Ignoring empty field in sum
 

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

Ignoring empty field in sum
 

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

Ignoring empty field in sum
 

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

Ignoring empty field in sum
 

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