Sorry but I am confused. When you say "We need to average sets of data from
a larger set. We want to take the total length of the data and divide it
into 10" I think about say 1000 cells as a "large set of data" But you go on
to talk about 360 FEET. And what is "start length"?

I think we need a clearer explanation of what you want to do - maybe with a
small sample data set.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Feolet20" wrote in message
...
This is a little confusing, so I'll try to explain. We need to average
sets
of data from a larger set. We want to take the total length of the data
and
divide it into 10. This gives us a section length that will change
depending
on how long our data set is. These sections will have a different range,
and
we want to average the range on each section.

For example.

If our total length is 10500, with the start length at 6900 and we divide
this into 10 sections, our sec length is 10500 - 6900 / 10 = 360 ft
sections.
We want to divide our data:

Depth Value
10 106
11 102
12 120
.
.
.

into these 360 feet sections. This means we'll average our Range 1
(reference B1000 - B740). How do we set up the formulas to divide these
out? We've got to where we can type in the total length and get our cell
reference #'s for each section, but how do we do an averaging formula that
uses those cell references we calculated?

Any help would be greatly appreciated