Forum Discussion
Help with COUNTIFS
Hello! I have a table with a list of transactions by date. I would like to count the number of times a phrase appears in a particular year. How many times did we list "General Operating Support" in 2...
I know there's probably a more elegant solution, especially if you are using the most current version of Excel, but I just added a helper column that contains this formula (copied down to all rows)
=YEAR(A2)
so that there's a single column that is only the year,
Then this formula gets your answers (with the flexibility of changing the year in cell E2
=COUNTIFS(C:C,E2,B:B,"General Operating Support")
See the attached.