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

will sum the last 5 entries in A3:A43 you can't obviously put the formula
within that range

or

=SUM(INDEX($A$3:$A$43,COUNT($A$3:$A$43)-4):INDEX($A$3:$A$43,COUNT($A$3:$A$43)))




--
Regards,

Peo Sjoblom

Portland, Oregon
(No private emails please)


"By-Tor" wrote in message
...
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.