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.

[FDibbins]

Hi and welcome to the forum

It might make it easier (for me at least) if you include a few sample answers, as well as how you arrived at them?

[kuanyaw]

Dear FDibbins,

i re attached the file on how i get the answer with 2 step

[FDibbins]

thanks

OK not sure if this will work for you, give it a shot and let me know. Copy this down and across to where you need it...
=SUMIFS(C$2:C$11,B$2:B$11,$A15)

[kuanyaw]

Thanks FDibbins.

If can i dont want to insert column B, D & F. I mean direct use 1 formula (or 1 step) to get the answer for summary of material type use qty. Because for each brand i input it require additional i column for material type use.