Hi,
You might consider using a pivot table to summarize your data, and then
group it by month. For help in getting started setting up your pivot tables
consider the following sites:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm
http://www.contextures.com/xlPivot02.html
http://www.contextures.com/xlPivot01.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm


"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an invoice by
month. I have things on this invoice that go back to January 2004. My dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am trying to
do this on a seperate worksheet from all of my data.

Thanks