| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
Linear Mode
