sum calculation

[shar]

How would I go about returning the sum of the QTY column for each unique
date. (You will notice that there are some rows with duplicate dates.) This
data comes to me in a delimited file and I need to have the output to
summarize the QTY per DATE. Thank you in advance, I appreciate your help.

ID DATE QTY
86621875 20050325000000 120000
86621875 20050330000000 100000
86621875 20050330000000 100000
86621875 20050413000000 80000
86621875 20050512000000 100000
86621875 20050413000000 80000
86621875 20050413000000 50000
86621875 20050413000000 50000
86621875 20050413000000 20000
86621875 20050613000000 100000
86621875 20050627000000 100000
86621875 20050701000000 100000
86621875 20050801000000 300000
86621875 20050901000000 200000
86621875 20051001000000 200000
86621875 20051101000000 200000
86621875 20051201000000 200000
86621875 20060101000000 100000
86621875 20060201000000 200000
86621875 20060301000000 200000
86621875 20060401000000 130000
86621875 20060501000000 620000
86621875 20060801000000 590000
86621875 20061101000000 580000
86621875 20070201000000 560000
86621875 20070430000000 1380000

 

[N Harkawat]

Use pivot table or
sort by date and then use data-subtotal

 

[Guest]

Hi

You could sort them into date order and use Data / Subtotal. Or you could
use Data / Pivot Table. For instructions, see here:
http://www.cpearson.com/excel/pivots.htm