Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproductif
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproductif
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"SUMPRODUCTIF" | Excel Worksheet Functions | |||
where is sumproductif | Excel Worksheet Functions |