SOLVED

# What formula to use

Occasional Contributor

# What formula to use

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 Replies
Best Response confirmed by Nikoss (Occasional Contributor)
Solution

# Re: What formula to use

@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.

# Re: What formula to use

Thank you so much!! That works!