Novice 2003 user. I hope someone can help. I have the following formula:

=IF(D160,SUMPRODUCT(($B$4:$BA$4C15)*($B$4:$BA$4< =C16),($B$6:$BA$6)*($B$4:$BA$4))/SUMPRODUCT(($B$4:$BA$4C15)*($B$4:$BA$4<=C16),($B$ 4:$BA$4)),"")

in D10:D48 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.

--
Mike

Try this Mike

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

--
__________________________________
HTH

Bob

"Mike" wrote in message
...
Novice 2003 user. I hope someone can help. I have the following formula:

=IF(D160,SUMPRODUCT(($B$4:$BA$4C15)*($B$4:$BA$4< =C16),($B$6:$BA$6)*($B$4:$BA$4))/SUMPRODUCT(($B$4:$BA$4C15)*($B$4:$BA$4<=C16),($B$ 4:$BA$4)),"")

in D10:D48 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.

--
Mike