Count projects for the month

Joseph Aloysias

I'm trying to calculate total "In Progress" projects for the month, I used the below formula to calculate,

=COUNTIFS([Actual End Date]:[Actual End Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1)), IFERROR(YEAR(@cell), 0) = YEAR(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1), [Project Status]:[Project Status], OR(@cell = "In progress")))

but I get #invalid data type error,

Paul Newcome

Lets try cleaning things up a bit first to see if that helps:

=COUNTIFS([Actual End Date]:[Actual End Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), [Project Status]:[Project Status], @cell = "In progress")

Paul Newcome

Happy to help. 👍️

Paul Newcome

Lets try cleaning things up a bit first to see if that helps:

=COUNTIFS([Actual End Date]:[Actual End Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), [Project Status]:[Project Status], @cell = "In progress")

Joseph Aloysias

@Paul Newcome you are great, its working! Thanks a lot

Paul Newcome

Happy to help. 👍️