Require Index & Match Formula

[rush2rajen]

Hi Excel Gurus,

I was trying out the index and match formula but somehow I am not bee able to.
I had made a data which had some condition. For eg.

There are 70 drs in 14 - 15 I want to take out out of 70 how many is on growth and de growth.

Please help.

Thanks
Raj

 

[Somendra Misra]

Hi Raj,

See the file, I had converted your data to table and put the formula in Yellow cells.

Regards,

 

[Hui]

E4: =COUNTIFS(JOHN!$O:$O,$A4,JOHN!$N:$N,E$2)
Copy across and down