Difficulty with CountIfs function

I'm trying to count values in a column that are not blank if a date column matches January. My formula is:

=COUNTIFS([Date]:[Date], MONTH(@cell) = 1, [Number]:[Number], <>"")

I get Invalid Data Type as the result. I can only think it has to do with the MONTH(@cell) portion, but I've used that in another summary field with the SUMIF function. Any ideas what's wrong with the syntax?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!