Hi, great site very helpful community so far, hopefully I can help others one day.
Today however I need some input on how to get this COUNTIFS to return a single number
=COUNTIFS(ZI_ENH_TAB!B:B,"PM01",ZI_ENH_TAB!CS:CS,MONTH(1)) what I am trying to achieve is to count the number of "PM01" values returned in column B but only for a given calendar month from the list of dates in column CS. the count of specific values in column B I can get right, it is counting that value only by the specified month I am having trouble with??

Please see attached sample sheet.

Kind regards

Heath