M
Mike
Not sure if this is possible or not. Excel 2003. No VBA experience. B4:IS4
has daily production output numbers. I am using a formula like
=COUNTIF($B$4:$IS$4,">625")-COUNTIF($B$4:$IS$4,">650") to find the count of
days where production output was between 626 - 650 pieces and goes in
intervals of 25 up to 1600 in D947. B6:IS6 has the % of scrap product (B6
is scrap % for pieces shipped in B4...etc). Is there a way I can average the
scrap % for the output ranges? For example, I have 5 days where the
production output was between 826 - 850 pieces. Can I find the scrap % for
those 5 days automatically?
has daily production output numbers. I am using a formula like
=COUNTIF($B$4:$IS$4,">625")-COUNTIF($B$4:$IS$4,">650") to find the count of
days where production output was between 626 - 650 pieces and goes in
intervals of 25 up to 1600 in D947. B6:IS6 has the % of scrap product (B6
is scrap % for pieces shipped in B4...etc). Is there a way I can average the
scrap % for the output ranges? For example, I have 5 days where the
production output was between 826 - 850 pieces. Can I find the scrap % for
those 5 days automatically?