Query related to show numbers according to its data

Iron Contributor

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..

4 Replies

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


best response confirmed by Excel (Iron Contributor)



Please try this...


In H2


and then copy it across and down.

Thank you very much sir.

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