SOLVED

Query related to show numbers according to its data

Super 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

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

 

best response confirmed by Zain123 (Super Contributor)
Solution

@Zain123 

 

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.

Thank you very much sir.

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