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.