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