Multiple functions use sum product with condition & Extracting range for each cell

[SKN2022]

Hello experts,
need help in extracting data from sheet
sample file attached
I used formula in I4, J5 cell but no value, so need to now what went wrong
now what I actually want is that
need to Extract data from column A named as Pile
for pile number 1 need sum product of B4:B20, H4:H20,
same for each pile number till 46

Second thing I want is for each pile range value from column H to be counted for different range as put in M3, N3, O3.

DATA 1.xlsx

Sheet1 Pile,Production,bench,Production,bench,SiO2,Al2O3,Fe2O3,CaO,LSF,Pile number,TOTAL SUMPRODUCT OF PRODUCTION * RANGE,RANGE BETWEEN 130 TO 150 ,RANGE above 150,RANGE BELOW 120 1,1164.48,I,11.38,I,11.38,1.38,0.50,46.61,138,1 1,1646.34,V,9.06,V,9.06,1.24,0.44,49.23,181,2 1,393.81,I,9.21,I,9.2...

docs.google.com

 

[Joe4]

i dont think just posting the formula will make u understand the requirement/query, even than putting few of them

=(SUMIFS($F$18:$F$1066,$L$18:$L$1066,">=190",$D$18:$D$1066,D4))/D5%
=(SUMIFS($F$18:$F$1066,$L$18:$L$1066,">=160",$D$18:$D$1066,D4)-SUMIFS($F$18:$F$1066,$L$18:$L$1066,">=180",$D$18:$D$1066,D4))/D5%
=SUMPRODUCT(D6:AX6,$D$5:$AX$5)/$C$5
=(SUMIFS($F$18:$F$1066,$L$18:$L$1066,">=80",$D$18:$D$1066,D4)-SUMIFS($F$18:$F$1066,$L$18:$L$1066,">=100",$D$18:$D$1066,D4))/D5%

That is fine to post the link in addition to your solution, for better context.
Thank you.

 

[jasonb75]

Simplifying the second and fourth formulas.

=SUMIFS($F$18:$F$1066,$L$18:$L$1066,">=160",$L$18:$L$1066,"<180",$D$18:$D$1066,D4)/D5%

=SUMIFS($F$18:$F$1066,$L$18:$L$1066,">=80",$L$18:$L$1066,"<100",$D$18:$D$1066,D4)/D5%