Sum last 6

[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?

 

[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))

 

[jk_target]

JE McGimpsey:

Thanks! Worked like a charm!

JK