Help! It's been a few years since I properly worked with excel and came to build a tracker today and was stuck with MI.

I have an excel spreadsheet with 10 tabs - 1 for each person in my team. On each tab I have entries for every day which I mark with date in column A and pass / fail column F.

I've made a YTD summary which shows me the % accuracy on each tab as a total % of pass / fail compared to total number of rows using the countif formula.

I now need to break that down into each month as well and that's where I am stuck. I'm not sure how to make a count of each month broken down into pass/ fail.

Hope that makes sense. Any help would be great!!