Formula Help: Count "To Do" for rows with start date in June

FactionPMO

I am currently using this function =COUNTIF(Status:Status, "To Do") to identify the total number of tasks with the status of "To Do". I'd now like to break this out to count the total number of "to do" that start in June for example. How can I add this additional ask for the date? Thanks!

Paul Newcome

There are a few ways to do this utilizing the COUNTIFS function. Here is what I recommend...

 

=COUNTIFS(Status:Status, "To Do", Date:Date, AND(IFERROR(YEAR(@cell), 0) = 2019, IFERROR(MONTH(@cell), 0) = 6))

FactionPMO

worked like a charm; thanks!

Paul Newcome

Excellent! Happy to help!