Moving average across variable range

Hi everyone, I am starting to use excel in a much more advanced way than i usually do, and have hit a wall. I don't really have the vocabulary to properly describe what I'm trying to do.

Essentially, I have a series of values that are attached to depths down a hole. I want to create a moving average of these values. Now, I can generate a moving average of, for example, nine values, four above and four below the centre point. However, what I need to do is create a moving average by DEPTH. So create a moving average of a varying number of cells, which all lie within a 3 metre interval centred on each row.

I need to create a formula that will interrogate all of the depths, compare them to the interval depth, and ascertain whether they are -1.5>0<1.5, and if so, sum the associated values so they can be analysed. (it'll obviously have to ignore the centre row though, otherwise it'll add it to itself, I think...)

The example layout (sorry for the crappy paste, not sure how to make it prettier) is:

Depth ALPHA
44.38 23
44.43 83
44.73 83
45.09 31
46.88 50
46.99 82
47.12 82
47.24 73
47.28 78
47.4 83
47.59 22
52.78 80
52.94 80
53.17 61
53.24 70
53.65 61
53.72 78
54 23
54.1 34
54.33 21

So what I want to do, ultimately, is generate a moving average of Alpha, for the three meters surrounding where it was measured...

Even if you don't know the solution, if you can advise the name of what I'm trying to do that'd be a big help.

Thanks, in advance!

You get better help on your question if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html