sum ifs formula

In sheet reed 96 in column k, i want numbers come from sheet manual 1 (according to column b15: C37.)

and in reed 96 sheet there is a dashboard in which m 124 will be according to column b (sheet reed 96) and n 124 will be according to column i(sheet reed 96) and q124 will be the total of column k of that design.

Please do it this is most important project

please help.

ok i have done dashboard requiremnt. now only need a formula which can import meters in column k in sheet reed 96, from manual 1 sheet (cell range b17:c27)

please do this only.
thanks in advance.

in sheet reed 96 in column k meters should be come according to column f, which should be match from manual 1 sheet
for example 90*100 metr is 2.45 (please see b17 & c17 in manual 1 sheet) it should be matched with f116 and value will be come in k116.

Hi to all. I have applied formula. Please check that.i want that when i fill m124 n124 o124. Then there should be come total required quantity of column i in p124 in reed 96.
And total of column k in the q 124 following the m124 n 124 o124.

While in column k meters should be come from sheet manual 1 cell range a15:f28
there are different & same values of 90*100-spl-2.45 and 90*100-bedsheet-3.1
in reed 96 column f and g should be look but value have to be pick up from manual 1 cell refernce a15:f28.