Calculate multiple or range in formula
I have created a sheet that reflect Projects end year and I'd like to count certain years.
I have the following formula:
=COUNTIF([Year Closed]:[Year Closed], "2023") that works well.
How do I calculate multiple years like 2022 & 2023, or a range 2020-2023 in one formula?
Help Article Resources
Check out the Formula Handbook template!