Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup to Return a Range of Data James Excel Discussion (Misc queries) 0 July 13th 06 09:44 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Excel 2002; copy formulas to one workbook to another diff data SinnetBS Excel Worksheet Functions 1 November 25th 05 08:31 PM
Automatically pasting worksheet data to new worksheet with formulas COntactJason Excel Worksheet Functions 0 August 10th 05 08:22 PM
Formulas in source data Ken Charts and Charting in Excel 3 December 1st 04 05:43 PM


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"