COUNTIFS function showing error
I am counting the nos. of specific activity within the specific month. (Two different columns)
Want this formula in the summary sheet. tried several ways but didn't get the desired results. I tried
=COUNTIFS([Activity Type]:[Activity Type], "Improvement", Month:Month, 1)
=COUNTIFS([Activity Type]:[Activity Type], "Improvement", [Month]:[Month], 1)
Showing result as "Invalid data type"
Please share your thoughts to fix this. Really appreciated.