|
sum calculation
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 |
Use pivot table or
sort by date and then use data-subtotal "shar" wrote in message ... 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 |
|
Hi
You could sort them into date order and use Data / Subtotal. Or you could use Data / Pivot Table. For instructions, see he http://www.cpearson.com/excel/pivots.htm -- Andy. "shar" wrote in message ... 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 |
| All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com