Difficulty with CountIfs function

Paul_S · 04/01/22

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 · 04/01/22

Is your Date column property set to Date type?

Paul Newcome · 04/01/22

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 · 04/05/22

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

Paul_S · 04/05/22

Yes, it is set to date type.

Paul_S · 04/05/22

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

Paul, Thank you. That worked perfectly.

Paul Newcome · 04/05/22

Happy to help. 👍️

Difficulty with CountIfs function

Answers

Help Article Resources

Categories