Ignoring empty field in sum

[Redsphynx]

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]

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

 

[T. Valko]

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)

 

[Ron@Buy]

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]

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