Thread: Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Excel

=SUM(A1:A5)/COUNTIF(A1:A5,"0")

Vaya con Dios,
Chuck, CABGx3


"Henry" wrote in message
...
i'm trying to do a sum of ( 5 diff Cells)and then / by number of cells

that
contain a number greater than zero. Any suggestions.