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.

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.

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.

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.

=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.

Thanks again, those came back as 0 when I tried them. I got it to work using:
=SUM(OFFSET($A$3:$A$43,$D$1-5,0,5,1))
$D$1 is a count of how many entries I have and it updates with each new
entry.

"Peo Sjoblom" wrote:

=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.