And needless to say, I *should* have said:

"Enter the row number of the cells to 'start' and 'end' into B1 & B2.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"RagDyeR" wrote in message
...
I didn't read the question as to performing any sort of calculation, but you
may be right.

SO ... to Sum a range of cells contained in Column A,
Enter the cell to *start* into B1,
And enter the *ending* cell into B2,
And try this:

=SUM(INDEX(A:A,B1):INDEX(A:A,B2))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Biff" wrote in message
...
Hi!


Ideally, if
there is a formula command that can point to a section of data in a column
like this, and perform an operation on it, that I can direct to a particular
cell, I would like to know how to do that.


There is, but you need to tell us *EXACTLY* what you want to do and tell us
*EXACTLY* where the data is.

For example, This formula, when copied down, will sum every 10 rows in
column A:

=SUM(OFFSET(A$1,(ROWS($1:1)-1)*10,,10))

The first cell will sum A1:A10
The next cell will sum A11:A20
The next cell will sum A21:A30
etc
etc

Biff

"Motown Mick" <Motown wrote in message
...
I have a column of data listed in ascending order. I would like to pull
sections of it out (i.e. 0-10, 11-20, etc.) without having to manually go
through the column and highlight that section, copy, paste, etc. Ideally,
if
there is a formula command that can point to a section of data in a column
like this, and perform an operation on it, that I can direct to a
particular
cell, I would like to know how to do that.

I can't figure out what version of Excel I have. It's whatever comes with
MS Windows XP.