If there is no production on a given day, then leave the cell blank rather
than enter 0%. AVERAGE() ignores blanks
--
Gary''s Student - gsnu200791


"HW" wrote:

ItemA ItemB ItemC
date1 34% 0% 91%
date2 0% 0% 12%
date3 100% 80% 90%

These are the percentage of how effective the production was for the day.
However, 0% does not mean not effective. It means no production was made on
that item. How do I average the production for the day, without it counting
the zeros?
Currently using:
=SUM(DX36:EI36)/(COUNTIF(DX36:EI36,"<0"))