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.

"ediddy" wrote:

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?

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

"ediddy" wrote:

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?