Invalid Data Type Error

Maddy Menna

Hi All,

I created a metric sheet for my Dashboard with a section to count how many store openings I will have in 2024. The formula is sourcing my Summary Sheet.

I entered the following formula into my cell:

=COUNTIF({Summary Sheet Range 2}, YEAR(@cell) = 2024)

Any ideas on why it's throwing an invalid data type error? Both columns are Text/Number.

Invalid Data Type Error.docx

Thanks for your help!

Maddy

Cory Page

The 2024 value in your example isn't a date format so you shouldn't need the Year() part in your formula. Remove that and you should be good to go

=COUNTIF({Summary Sheet Range 2}, @cell = 2024)

Cory Page

The 2024 value in your example isn't a date format so you shouldn't need the Year() part in your formula. Remove that and you should be good to go

=COUNTIF({Summary Sheet Range 2}, @cell = 2024)

Maddy Menna

You're awesome! It worked. Thanks so much for the quick response!😀