Put first formula =SUM(A2:C2) in whatever cell you wanted, lets assume A5.
Put next formula =SUM(D2:F2) in cell 3 cells to the right, eg D5. Now
select A5:F5. Now grab the fill handle and fill right as far as necessary
(lets assume IV5).
When done simply select A5:IV5, do Edit / Go To / Special / Blank cells,
then do edit / delete / shift cells to left.

Job done

Regards
Ken.........................



"Steve" wrote in message
...
I am converting a monthly revenue table to a quarterly revenue table. I
would
like to add A1:C1 and put it the result in a new cell and then autofill
the
cell to the right of it so that it automatically adds D1:F1 for the next
value
A B C D E F
1 Jan Feb March April May June
2 10 12 12 13 14 15

Qtr1 Qtr 2 Qtr 3
sum A2:C2 Sum D2:F2 Etc... using autofill
currently using autofill the first qtr is correct "=Sum(A2:C2) but the
next
cell gets filled with "=sum(B2:D2) instead of adding the next 3 months.

I appreciate anyone's help!