| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Sum Dates
I have a worksheet with multiple appearances of various dates in column "a".
In column "b" I have dollar amounts. Is there a way to write a formula that will look up all similar dates in column "a" and add up the corresponding values from column "b" and put them in the next column? I have about 3000 lines per worksheet, so doing the SUMIF function with ranges each time is not conduscive. |
|
#2
|
|||
|
|||
|
On Thu, 29 Sep 2005 11:15:04 -0700, "riseazufall"
wrote: I have a worksheet with multiple appearances of various dates in column "a". In column "b" I have dollar amounts. Is there a way to write a formula that will look up all similar dates in column "a" and add up the corresponding values from column "b" and put them in the next column? I have about 3000 lines per worksheet, so doing the SUMIF function with ranges each time is not conduscive. Have you tried a pivot table? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#3
|
|||
|
|||
|
I'm not that experienced in Pivot Tables, however with some direction, I
could possibly figure it out? Thank you for your response! "Richard Buttrey" wrote: On Thu, 29 Sep 2005 11:15:04 -0700, "riseazufall" wrote: I have a worksheet with multiple appearances of various dates in column "a". In column "b" I have dollar amounts. Is there a way to write a formula that will look up all similar dates in column "a" and add up the corresponding values from column "b" and put them in the next column? I have about 3000 lines per worksheet, so doing the SUMIF function with ranges each time is not conduscive. Have you tried a pivot table? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#4
|
|||
|
|||
|
Try the pivot table approach.
riseazufall wrote: I have a worksheet with multiple appearances of various dates in column "a". In column "b" I have dollar amounts. Is there a way to write a formula that will look up all similar dates in column "a" and add up the corresponding values from column "b" and put them in the next column? I have about 3000 lines per worksheet, so doing the SUMIF function with ranges each time is not conduscive. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Default Dates | Excel Discussion (Misc queries) | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
Hybrid Mode
