Day and Date function

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

Thanks

 

[Scott T]

Your picture does not display. Can you explain what your sheet looks like or use the table function to show it.