#INVALID DATA TYPE when counting column without a value

Hi guys, im trying to use CountIFs to count all projects that have a completion date by month. Not all projects are complete so there that are those that do not have an end date has the error #invalid data type".

I tried using this formula, but didn't work. Could I have assistance fixing the formula? If there is an invalid data type, it just wouldn't count that line or return 0 as a value.

=COUNTIFS([Completion Month]:[Completion Month], "January", IFERROR([Completion Month]1, 0))

but I need to do a countifs for all months January-December.

Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!