Thread
:
Excel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
CLR
Posts: n/a
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.
Reply With Quote