ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Offsetting formulas for consecutive data sets (https://www.excelbanter.com/excel-discussion-misc-queries/104795-offsetting-formulas-consecutive-data-sets.html)

[email protected]

Offsetting formulas for consecutive data sets
 
I need to create a formula that is easily "drag-downable" of the
following form - say I have a column of numbers and i want to sum each
2 like this :

1 6
5 15
3 21
12
15
6


So that the 6 is 1+5, the 7 is 3+12, 11 is 15+6. At the moment I have
this formula :

=SUM(OFFSET($A$1,ROW(1:1)*2-2,0,2,1))

which works but was wondering if there was a more easy / obvious way to
do this ... ?

Many thanks,
Francis.



All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com