counting last seven in row

J

judoist

I have a database with a row of numbers. A new number is added to th
row every day. Does anyone know what to use so that the last seve
digits are counted each time without me having to constantly adjust th
formula
 
F

Frank Kabel

Hi
if you mean summing these values and if you don't have any blank rows
in between try:
=SUM(OFFSET($A$1,COUNTA(A:A)-1,0,-7))
 
Top