Hi
supposing all your values are contiguous and of course numbers, the following will give the sum of the last 8 cells
Code:
=SUM(INDEX(A:A,COUNTA(A:A)):INDEX(A:A,COUNTA(A:A)-7))
The part after the SUM function defines a range comprising the 8 last values.In fact many XL users forget that INDEX returns a reference to a cell when used in another formula. That is what we are taking advantage of here
If you have any other requirements perhaps post a sample
sheet on the forum please . Thx