Difficulty with CountIfs function

Paul_S

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?

Sameer Karkhanis

Is your Date column property set to Date type?

Paul Newcome

Try this...

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

If there are blanks or text values anywhere in the date column being referenced, you will get the error.

Paul_S

https://community.smartsheet.com/discussion/comment/324813#Comment_324813

https://community.smartsheet.com/discussion/comment/324813#Comment_324813

https://community.smartsheet.com/discussion/comment/324813#Comment_324813

Paul_S

Yes, it is set to date type.

Paul_S

https://community.smartsheet.com/discussion/comment/324820#Comment_324820

Paul, Thank you. That worked perfectly.

Paul Newcome

Happy to help. 👍️