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?

Find more posts tagged with

Accepted answers

All comments

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

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.