What formula to use

[Nikoss]

Hi all, i am trying to figure which formula would work better for the following but my mind is stuck (see screenshot of my spreadsheet attached):

I am trying to count how many cells in column AH will contain the word "Yes" for each month (month will be shown in Column C). What formula do I need to use to count the "Yes" cells in column AH for January for example?

Thank you

[#2 · Accepted solution]

@Nikoss  I would think COUNTIFS() would work: 

=COUNTIFS(AH:AH,"Yes",C:C,"January")

that said it does depend on if "January" is text or actual date format and either way could be replaced using another cell.  For example if you had a summary table with Jan, Feb,... in a column (again in the same format as column C) then just reference that cell so when you fill down you get each month.

[#3]

Thank you so much!! That works!