Forum Discussion
How to add a list of values in one column based on the data in another column
I have two columns with Dates, eg. Apr 1, 20, Apr 2, 20, and another with values. I want to add all the values in each date. Apr 1, 20 243.41 Apr 1, 20 15.99 Apr 1, 20 45.99 Apr 2, 20 46.99 ...
You can use pivot table to summarise sales by each date. Alternatively use unique function on column with dates and then sumifs function to summarise sales for the dates from unique function output.
Artur
Regards
Artur
Artur
Regards
Artur