Sumproductif

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top