=SUM(C21:C25)/COUNTIF(C21:C25,"0")
equals 5
Cheers! Brad
"phil-rge-ee" wrote in message
...
I have a cells C21 thru C45 that have numbers in them. I need to add them
all
together and then divide by the number of cells that have a number greater
than 0 in them. This would be used to get an average number. If the cell
is 0
then I don't want to include it in the dividing process. Example:
C21 is 5
C22 is 3
C23 is 0
C24 is 7
C25 is 0
I would need the formula or VB script to add the numbers then divide by 3
(not divide by 5 - eliminating the cells with 0 in them) So the answer in
the
example here would be 5, not 3. (15 divided by 3).
Thanks for any help.
Phil