#Invalid Data Type

Paige_Hamby

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())

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?