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...
If you want to stick with COUNTIFS, the following should work:
=COUNTIFS(A:A,"<01/01/2012",A:A,">31/12/2010",B:B,"General Operating Support")
NB! My date format is dd/mm/yyyy, you will need to tweak this for your date format.