# Count projects for the month

Options
✭✭✭✭✭

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,

Tags:

• ✭✭✭✭✭✭
Options

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")

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• ✭✭✭✭✭✭
Options

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")

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭