Hello all, I’m having some issues with count if. I have a spread sheet that records exam results. I have a column (Column A)with dates and a column with results (Column C). Each Cell in column C has a drop down list. Pass, Fail, Waiting results. I want to check column C for how many exams are ‘Waiting Results’ depending on the year in column A My formula is this =COUNT(IF(YEAR($A$2:$A$50)=2017,$C$2:$C50,”Waiting Results*). This formula does not throw up any errors but the results it gives me is only a count of how many times 2017 appears in column A, but I want to know how many exams are waiting results for a specific year (in this case 2017). Any help would be greatly appriciated.