M
Mike
Novice 2003 user. I hope someone can help. I have the following formula:
=IF(D16>0,SUMPRODUCT(($B$4:$BA$4>C15)*($B$4:$BA$4<=C16),($B$6:$BA$6)*($B$4:$BA$4))/SUMPRODUCT(($B$4:$BA$4>C15)*($B$4:$BA$4<=C16),($B$4:$BA$4)),"")
in D1048 which is tracking the % of rejected product I have in a given
range of product production. My potential data range for product in the
sheet is B4:IS4 and B6:IS6. I would like to modify my formula above so that
I don't have to go into each day to adjust the range after I input that day's
data. If I use the extended range I get #VALUE! because there is no data
past BA4 and BA6 today. Any help would be appreciated.
=IF(D16>0,SUMPRODUCT(($B$4:$BA$4>C15)*($B$4:$BA$4<=C16),($B$6:$BA$6)*($B$4:$BA$4))/SUMPRODUCT(($B$4:$BA$4>C15)*($B$4:$BA$4<=C16),($B$4:$BA$4)),"")
in D1048 which is tracking the % of rejected product I have in a given
range of product production. My potential data range for product in the
sheet is B4:IS4 and B6:IS6. I would like to modify my formula above so that
I don't have to go into each day to adjust the range after I input that day's
data. If I use the extended range I get #VALUE! because there is no data
past BA4 and BA6 today. Any help would be appreciated.