Production Yields

  • Thread starter Thread starter HW
  • Start date Start date
H

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"))
 
If there is no production on a given day, then leave the cell blank rather
than enter 0%. AVERAGE() ignores blanks
 
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(B2:D2>0,B2:D2))
Copy E2 down
 
Back
Top