Sumproductif

[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.

 

[Bob Phillips]

Try this Mike

=IF(D16>0,SUMPRODUCT(($B$4:$IS$4>C15)*($B$4:$IS$4<=C16),($B$6:$IS$6),($B$4:$IS$4))
/SUMPRODUCT(($B$4:$IS$4>C15)*($B$4:$IS$4<=C16),($B$4:$IS$4)),"")