Count if formula to include multiple years

PaigeKucz

Hello,

I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024?

Current equation: =COUNTIF({CI Tracker Range 1}, @cell = YEAR(TODAY()))

Thank you!

Nick Korna

Hi @PaigeKucz

This would do this year and last:

=COUNTIF({CI Tracker Range 1}, OR(@cell = YEAR(TODAY()), @cell = YEAR(TODAY()) - 1))

If you wanted specific years, then just sub out the "YEAR(TODAY()" portions of the formula for the relevant year .