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 ...
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.