Home |
Search |
Today's Posts |
#1
|
|||
|
|||
summation y years
If I have a series of varied payments on different dates over many years, is
there an easy way to sum for each year? In one column will be the actual dates, but they may not be in order, and in another column will be the $ amounts corresponding to the dates. Thanks for any help. -- David |
#2
|
|||
|
|||
Use a pivot table - you can group by year.
See http://peltiertech.com/Excel/Pivots/pivotstart.htm and http://www.contextures.com/xlPivot07.html In article , "David" wrote: If I have a series of varied payments on different dates over many years, is there an easy way to sum for each year? In one column will be the actual dates, but they may not be in order, and in another column will be the $ amounts corresponding to the dates. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel calendar years | Excel Discussion (Misc queries) | |||
excel calendar years | Excel Discussion (Misc queries) | |||
Converting months to years | Excel Worksheet Functions | |||
Help with Years of Service formula.... | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |