Re: Spreadsheet cell notation

[prev] [thread] [next] [lurker] [Date index for 2004/03/26]

On Mon, 19 Jan 2004 Mark Fowler wrote:

>  d) When the spreadsheet goes to three dimensions (i.e. it has multiple
>     'sheets' in the book) it goes truly insane.  Now I have to write
>     this in Excel:
>
>       ='Sheet 1'!A1 + 'Sheet2'!A1 + 'Sheet3'!A1
>
>     Yep that's right.  I have to remember what my sheets are called.
>     Well *that's* reusable.  And can I just use a =SUM(...).  Nope, gotta
>     do each of the sheets individually.


You can write the sum as something like:

    =SUM(Sheet1:Sheet3!A1)

If you hate A1 notation you should try R1C1 notation. That will make
you apoplectic. ;-)


John.
-- 

• Spreadsheet cell notation Mark Fowler 15:59 on 19 Jan 2004
  • Re: Spreadsheet cell notation peter (Peter da Silva) 16:42 on 19 Jan 2004
  • John McNamara 22:30 on 26 Mar 2004

Generated at 14:02 on 01 Jul 2004 by mariachi 0.52