Forum Discussion
Help Please
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.
1 Reply
joshuafleming I would use a pivot table.
Date in the Row field, Action in the Column Field and Action in the Value field.
Dates should be grouped by year, quarter, month automatically provided you have real dates.
and the value field will be set to count as you are dealing with texts from the Action column.
