Please help : Sum of column based on multiple criteria

[kamalchandra.15]

Please find my excel sheet. i had explain query in it.
i m unable to solve it. its just a example. my data sheet is very big .

Please help

[:) Sixthsense :)]

Just sort the E6:H9 Data based on Column E data

Apply the below formula in C5 cell

=IFERROR(SUM(OFFSET($F$5,MATCH($B5,$E$6:$E$9,0),,LOOKUP(2,1/(E6:E9=B5),ROW(E6:E9)-MIN(ROW(E6:E9))+1),MATCH(C$4,$F$5:$H$5,0))),"")

Drag it down…

But better approach is use Pivot Table

[FDibbins]

try this...
=SUMIF($E$6:$E$9,B5,OFFSET(E5,1,MATCH($C$4,$E$5:$H$5,0)-1,COUNTA($E$5:$E$9,0)))

[kamalchandra.15]

thanks both of you.
its really helpful

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and thanks for the feedback