#Invalid Data Type

Hello,

I have a formula in my sheet summary that was working until recently. For some reason the formula is no longer able to count the months or years in the sheet. I also receive the error when I remove the [Current Month]# from the formula and try putting "11".

Does anyone have any recommendations or see anything wrong with the below formulas?

=COUNTIFS([Document Type]:[Document Type], "Net New", ERP:ERP, "NetSuite", Month:Month, [Current Month]#, Year:Year, [Current Year]#)

Current Month Summary Field is: =MONTH(TODAY())

Current Year Summary Field is: =YEAR(TODAY())

Find more posts tagged with

Sheets

Formulas

Sheet Summary

Accepted answers

All comments

Paul Newcome

Double check the Month and Year columns. If that error is in any of those cells, it will push through and cause the same error to appear in any formula referencing the cell.

Paige_Hamby

Sadly that's not the issue in this one :( the month and year columns are both column formulas and they have no errors in them. I had thought of that too when I saw them pop up.

Paul Newcome

What about either of the other two columns being referenced?

Paige_Hamby

No, the other columns being referenced are dropdowns from a form so they don't have any error messages. If I remove Month:Month, [Current Month]#, Year:Year, [Current Year]# from the formula, it works. And if I do =COUNT(Month:Month, [Current Month#), it works. But stops working when I try countif or countifs.

Paul Newcome

What happens when you leave the Month:Month range in and take out the Year:Year range?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.