Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to dates column with values in next column
I have a series of dates in the left column and values in the right column.
How can I consolidate the dates and sum the values of each date? i.e. OrderDate Face Value 4/17/2005 $2.00 4/17/2005 $2.00 4/17/2005 $5.00 4/17/2005 $5.00 4/17/2005 $2.00 4/16/2005 $2.00 4/16/2005 $5.00 4/16/2005 $5.00 4/16/2005 $2.00 4/16/2005 $5.00 4/15/2005 $5.00 4/15/2005 $5.00 4/15/2005 $2.00 4/15/2005 $2.00 4/15/2005 $2.00 4/15/2005 $2.00 4/15/2005 $2.00 4/15/2005 $2.00 4/15/2005 $5.00 4/15/2005 $2.00 4/15/2005 $2.00 4/15/2005 $2.00 4/15/2005 $10.00 4/15/2005 $5.00 4/15/2005 $5.00 4/15/2005 $2.00 4/14/2005 $2.00 4/14/2005 $2.00 4/14/2005 $5.00 4/14/2005 $2.00 4/14/2005 $5.00 4/13/2005 $5.00 4/13/2005 $2.00 4/13/2005 $5.00 4/13/2005 $2.00 4/13/2005 $5.00 4/13/2005 $5.00 4/13/2005 $10.00 4/13/2005 $2.00 4/13/2005 $5.00 4/13/2005 $5.00 4/13/2005 $2.00 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check column of dates against todays date | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Last several values in a column | Excel Worksheet Functions | |||
Finding the max of a column where values less than a specified number | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |