Sum only the last ten

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

Guest

I have a list in excel that is 52 enteries and I would like to know how to
sum only the last ten entries in this list and also have it adjust itself
when a new entry is added?
 
Hi ediddy,
Try,
=SUM(OFFSET(a1,MAX(0,COUNTA(a:a)-10),0,10,1))

This assumes that the data starts in cell a1 and that there are no breaks in
the data.
 
With entries starting in A1 and going down col. A, try:

=SUM(INDEX(A:A,COUNT(A:A)):INDEX(A:A,COUNT(A:A)-9))

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation...I need to add more entries!! 4
Top Ten Albums 10
Summary from multiple sheets 1
Format dates & add ten years to date 1
Offset with Blank Rows? 14
create a cell that accumulates, numbers from another cell... 1
Macro sum 1
sum last 3 numbers greater that 0 in a range 0

Back
Top