Query related to show numbers according to its data

[Excel]

Hello Everyone, 

I want to show NUMBER for A and S to a main data.

I tried the INDEX with MATCH function. But it did not work. 

Please help..

Here is a attached file..

[#2]

@Excel Try with SUMIFS or why not just a simple pivot table?

[#3 · Accepted solution]

@Excel 

Please try this...

In H2

=IFERROR(INDEX($C$2:$C$9,MATCH(1,INDEX(($A$2:$A$9=$G2)*($B$2:$B$9=H$1),),0)),"")

and then copy it across and down.

[#4]

Thank you very much sir.

[#5]

You're welcome @Excel! Glad I could help.