Sum last 6

  • Thread starter Thread starter jk_target
  • Start date Start date
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?
 
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))
 
Back
Top