J
Justinalexander
If I have a formula such as SUM(A1:A12) and drag/copy it one cell down
it becomes SUM(A2:A13), but what if I only want to use each cell once,
say to convert monthly data to annual data. so that dragging the
formula down would give:
SUM(A13:A24) then
SUM(A25:A36)
SUM(A37:A48) etc.
it becomes SUM(A2:A13), but what if I only want to use each cell once,
say to convert monthly data to annual data. so that dragging the
formula down would give:
SUM(A13:A24) then
SUM(A25:A36)
SUM(A37:A48) etc.