I have a spreadsheet where The date is in one column and whether the item has been actioned  is another column.

I currently use a COUNTIF formula to show a total for each category (Not Started / In Progress / Completed), however the data goes back over three years.

I am looking for a formula where I can show each categories number value for each year.

​I have a spreadsheet where The date is in one column and whether the item has been actioned  is another column.I currently use a COUNTIF formula to show a total for each category (Not Started / In Progress / Completed), however the data goes back over three years.I am looking for a formula where I can show each categories number value for each year.  Read More

​