How can you sum the last 5 columns of data from a range of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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!
 
Hang on that did it, I just had to adjust the offset command a little better.
Thanks Much!
 
=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)
 
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.
 
Back
Top