LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
George
 
Posts: n/a
Default named range, offset self-reference

On Sun, 6 Nov 2005 19:32:03 -0000, "Bob Phillips"
wrote:

What dictates that A2 is 0?


Manually set. It could be whatever.


And what would A3 be in your example?


Anything? It doesn't have any connection to row 2.

In row 2, I want each cell to be the sum of the cell on its left plus
the cell immediately above.

G
 
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
named range with filter dee Excel Worksheet Functions 3 October 17th 05 04:46 PM
Can I use named range in data range box when creating pie chart? BJackson Charts and Charting in Excel 2 August 17th 05 05:37 PM
Passing Excel NAMED Range to VBA BG Excel Worksheet Functions 4 July 28th 05 05:23 PM
Dynamic named range across multiple sheets babycody Excel Discussion (Misc queries) 3 July 24th 05 06:03 AM
Question for use of offset and range Demi Excel Worksheet Functions 3 July 22nd 05 08:48 PM


All times are GMT +1. The time now is 09:09 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"