Hi,

This will throw an error if there are less than 3 rows. If that's a problem
post back.

=SUM(OFFSET(A1,COUNTA(A:A)-3,):OFFSET(A1,COUNTA(A:A),))

Mike

Mike

"Margs" wrote:

I have a column where I enter a figure in a row once a day. I would like to
add up the last three rows only so that no matter how many numbers are
entered in the column I am only working with the last three entries.
I cannot find the answer in any of my books.
Many thanks