ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel (https://www.excelbanter.com/excel-worksheet-functions/75001-excel.html)

Henry

Excel

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.

CLR

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.

All times are GMT +1. The time now is 09:52 AM.