View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.