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
Apr 2, 20 56.99
Apr 3, 20 67.99
...
This is a list of each sale in Column with the date of the sale in column A.
I want to get a total of all sales on each date.
For example:
Apr 1, 20 1456.99
Apr 2, 20 2679.03
Apr 3, 20 4334.09
2 Replies
dannyowsnett If you could clean up the data before summarising, that would help. Get rid of the sub-totals and empty rows. Then you can use a pivot table to sum the amounts per date. See attached.
By the way, any reason why you are saving the the file in a very old (Excel 1997-2004) xls format? I've saved it as an xlsx file.
- 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
