Hi,


I have a worksheet that contains the daily production of a given product and i trying to generate a formula that allows me to see, for example, how many tons of products are in the painting process during week 18.

the expected result should be 7,877.6 tons were in the painting process in week 18.

I have tried to following formula to solve it: =SUMPRODUCT(($L$17:$AP$17=$F5)*($L$19:$AP$22=G5)*$F$19:$F$22)/SUMPRODUCT(($L$17:$AP$17=$F5)*($L$19:$AP$22=G5))

But the divisor formula has to be fixed and i couldn't figure out the best way to do it.

Any way i have my file attached, so anyone can see and help me to figure out the best way to solve it.


ThanksWorking in Progress.xlsx