MONTH formula when referencing another sheet doesn't like blanks.

I've got this formula:

=COUNTIFS({Improve system Range 2}, MONTH(@cell) = 1)

It counts how many dates in a specific month (January in this instance). However if I select the entire column, it errors (#INVALID DATA TYPE) as it can't handle blank cells.

Smartsheet by default puts a number of blank cells at the bottom of the grid, so there's no getting away from having blank cells.

Anyone know how I'd modify this formula to make it work so It can deal with blanks? I'd assume I'd need some kind of 'Ignore if <0' but I don't quite know how to do this.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!