Hi there. I want to find out how to use COUNTIFS using 3 criterion:

JackieChawke

Hi there. I want to find out how to use COUNTIFS using 3 criterion:

How many "Complete" tasks have been done in the month of "January 2025" for the workstream titled "Event Delivery"?

Carson Penticuff

You will have to adjust the formula to match your column names, but this is the general idea:

=COUNTIFS([Task Status]:[Task Status], "Complete", [Task Completion Date]:[Task Completion Date], ISDATE(@cell), [Task Completion Date]:[Task Completion Date], YEAR(@cell) = 2025, [Task Completion Date]:[Task Completion Date], MONTH(@cell) = 1, [Workstream Title]:[Workstream Title], "Event Delivery")