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...
=SUMPRODUCT((YEAR($A$2:$A$34)=E2)*($B$2:$B$34="General Operating Support"))
Does this return the expected result?