Hang on that did it, I just had to adjust the offset command a little better.
Thanks Much!

"By-Tor" wrote:

Not exactly, let me rephrase it on a smaller scale.
I have a range to enter data from say a3 to a43 and I want to sum only the
last 5 fields of data entered. So say I have data entered up to a15, then I
am trying to figure out a way to sum all data from only a11 to a15, but then
when I enter data on line a16 I want it to sum only the data from a12 to a16.
I tried to play with the formula written in the last post but the best
result I could get was volatile. Thanks!

"Peo Sjoblom" wrote:

Son you want to sum the last row like if A15 is the last row you want to sum
A11:G15?

=SUM(OFFSET($A$3,COUNT($A$3:$A$43)-1,,-5,7))



--
Regards,

Peo Sjoblom

Portland, Oregon
(No private emails please)


"By-Tor" wrote in message
...
I have a range of data that ranges from a3 to g43. Some of the range is
empty
of data but I enter new data daily. So say the data is currently entered
through row 15. Is there a way I can sum just the last 5 rows of entered
data and have it update automatically whenever I add in a new row of data
into the already established range? Hope that is clear enough.