COUNTIF Function or a substitue formula

[Alysiin P]

OK I am trying to build a leave tracking for my organisation. I want the the tracking tab to obtain its information for the month from the leave planning tab. This information is entered as letters. The countifs function gives me an error, the countif means I have to copy and paste this formula and edit for each month of the year and for each Staff too.

Which formula can I use which will pick out the letter, the staff and month automatically



Please your help is highly appreciated.

Thanks

 

[DanteAmor]

You can put the formula and a couple of examples of what you expect