| 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. |
| 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 | |||
Threaded Mode
