Sum last 6

J

jk_target

I have a column with 52 rows for each week in a year. In the 53rd
row, I need a formula to sum the last 6 non-zero values. This is to
represent the most current 6-week sum. As data for each week is
added, the formula will sum a different range. Any ideas?
 
J

JE McGimpsey

one way:

Assume 52 rows of data start in A2 and end in A53. Then in A54:

=SUM(OFFSET(A2,COUNTA(A2:A53)-6,0,6,1))
 
Top