Forum Discussion
joshuafleming
Aug 02, 2024Copper Contributor
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 ...
Riny_van_Eekelen
Aug 02, 2024Platinum Contributor
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.