Date & Sum Formula Help

Scott2023

I understand, and I appreciate the assistance! I just plugged in your formula and also returned a 120 correct value. Recapping below:

COUNTIFS({Assessment Status Column}, @cell = "Complete")

Returned 120

=COUNTIFS({End Date}, ISDATE(@cell))

Returned 120

Paul Newcome

Ok. So we DEFINITELY have dates. What about this one...

=COUNTIFS({End Date}, IFERROR(YEAR(@cell), 0) = 2023)

Scott2023

Reponse is #Invalid Data type

Paul Newcome

You get that error even with the built in IFERROR?? And you are putting this in a text/number type column?

Scott2023

I needed the proper spacing. I just tried again, and it worked!! Thank you for your patience and time much appreciated!!

Paul Newcome

Happy to help. 👍️