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