Need help with formula with dependent on multi criteria

[kuanyaw]

i have a workbook with 2 worksheet. 1st is " Raw Data Sheet" which contain item list vs Brand & type of material use. 2nd is "Cal Sheet" which the Item list fix & Brand & quantity of each item vs brand to be fill up. i need help on formula to sum quantity of material use base on 2 criteria (item & Brand) Item list fix but brand in row 1 area changeable.

i had try with Index & Match to look up "material use" first then only use sumif or sum (if..) to get the result. But it is become many step.

Can anybody help on this issue with 1 step to get the answer?


Thank you.