Build a uDF as I suggested earlier.

Function Sum3Above(rng As Range)
Application.Volatile
If rng.Cells.Count = 1 Then
If rng.Row 1 Then Sum3Above = rng.Offset(-1, 0)
If rng.Row 2 Then Sum3Above = Sum3Above + rng.Offset(-2, 0)
If rng.Row 3 Then Sum3Above = Sum3Above + rng.Offset(-3, 0)
End If
End Function


And call like H12: =Sum3Above(H12)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Werner Rohrmoser" wrote in message
...
Lori,

I've made further tests as well and your Excel calculation description
helped me to find out that there is a difference between
using a named formula with relative references and to use a named
relative range
in a formula on a worksheet.

=SUM_Something_Formula vs SUM(Something_relative_Range)

The first possibility has no precednets (checked with the detective)
but the
2nd one has precedents.
So if you test both possibilities the first one doesn't calculate and
the second one does.

This has somekind of logic in connection with the Excel calculation
behaviour.
What's your opinion?

Regards
Werner