Counting rows that contain specific years
I'm trying to create a formula in my sheet summary that will count the number or projects that contain a specific year in a column that shows the start date for the project. I have a task list spreadsheet and it contains tasks that started in multiple years but I'd like to be able to show metrics on our dashboard for how many projects we started in each year. It currently only counts the total number of projects on the sheet.
Help Article Resources
Check out the Formula Handbook template!