The easiest solution is probably just to type the correct formula in the
cells for Q2 etc. Another solution is a follows:

Suppose your month data is in Cells A2:L2

Q1, in A4 is =SUM(A2:C2)
Copy A4 to D4. Then drag D4 to B4.

Art

"vmagal1" wrote:

I have values for Jan - Dec and need to sum them by quarter on another sheet.
When I try to drag the formula across for Q2, Q3, and Q4, it won't grab the
corresponding months, instead it takes the consecutive numbers and sums them.
How can I fix this?