Production Yields

[HW]

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"))

 

[Gary''s Student]

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

 

[Max]

Assuming the data is in cols B to D,
you could try something like this in E2,
array-entered (press CTRL+SHIFT+ENTER):
=AVERAGE(IF(B22>0,B22))
Copy E2 down