INDEX MATCH multi criteria

[3345james]

For the life of me I'm having a problem figuring out an Index match formula. I rarely use it much but this application needs it.

Sheet 1 is to be considered a pivot table (Depending on filters the position of the BC-3 can move up or down)
I'm trying to fill in sheet 2.

Find BC-3 & corresponding month and populate the count the appropriate cell in the chart.
Sheet 2 also has what it should look like.

TKS Jim

[BadlySpelledBuoy]

In C13 and copied right:

Please Login or Register  to view this content.

BSB

[3345james]

Thank you so much!

[BadlySpelledBuoy]

Happy to help

BSB