Counting

C

croyals

I Have the sum of A:1 thru A:10 in Cell A:11. These cells have
formula already in each of them which is the sum of Say B:1- C:1 whic
is 0 until numbers are added. I am trying to divide by a count of cell
which have numbers greater than 0, My problem is excell counts the
in each cell instead of only cells with number
 
P

Paul B

Croyals, you can use something like this to count cells > 0, will that help
you?
=COUNTIF($A$1:$A$10,">0")
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Top