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

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:D20,B2:D2))
Copy E2 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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"))