Hi,
I have monthly totals for several years. Want to keep all totals but only
add the most recent 12 month total. Is there a quick way to do that vs.
revising the formula monthly?

Example:

Cell: A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2 N2 O2 P2
#: 1 3 2 1 2 2 1 2 1 3 1 1 2 3 2
2

1st Formula: =SUM(A2:L2)
Next Formula: =SUM(B2:M2)

What's the easy way to shift the 12 cells 1 cell to the right?

Many thanks, in advance, for your help.