Ok.....

Set up some cells to hold your value ranges:

............C...........D.............E.....
1.........0..........249.......formula
2.......250........499.......formula
3.......500........749.......formula

Assume the range of numbers is in A1:A25

Enter this formula in E1 and copy down as needed:

=SUMIF(A$1:A$25,"="&C1)-SUMIF(A$1:A$25,""&D1)

Biff

"Motown Mick" wrote in message
...
Biff,

This is almost like what I want to do except that:

1. Say I'm dealing with Column A. I'm looking for a way to sum by VALUE,
not cell designation. So rather than summing A1:A10, A11:A20, I would
like
to know how to sum all the entries in Column A that actually have an
entered
data value of, say, 0-249, 250-499, etc.

2. A formula that can be copied and dragged down is not necessary. If I
could just get a formula that could be applied to each of those data
ranges,
that would do the trick for me.

Thanks.

Motown Mick

"Biff" wrote:

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.