Alex - Data is in Row 1, so monthly data for year 1 is in A1..L1. Right now,
I'm typing sum(a1.c1) in A2, sum(d1.f1) in B2, etc. I want to automate this.

"Alex" wrote:

It depends on where you want to put the info..
do you want to put the information on another worksheet or on the same
worksheet? also do you want to put the info at the end of all of those
columns or do you want to do put it at the end...in between add a column
between c and d then put a = sign in the column next to the 3 boxes you want
to add, then the reference numbers to those boxes example =a1+b1+c1 press
enter and the box will show the answer. You can then select the box with
your mouse and you will highlight the box (note the box will have a dark
black small box in the bottom right hand corner) grab that little box and
drag to end of column where info is to be added... it will automatically
populate boxes.. let me know if this helps... let me know if you have any
questions

"Jeff" wrote:

Can anyone devise a formula to summarize monthly data by adding each three
months? That is, I need to add columns A-C, D-F, G-I, etc. I've been doing
this manually, but there must be a better way. Thanks.