View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 57
Default formula help needed for averages

=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