ExcelBanter - Rolling 4 Week Sum

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Rolling 4 Week Sum (https://www.excelbanter.com/new-users-excel/447339-rolling-4-week-sum.html)

ExcelNewbieUK

Rolling 4 Week Sum

Hi there,

I am trying to get a rolling 4 week sum. The weeks are in row 4 and continue until the end of the year.

The data is in rows 5 downwards.

I want the end column to show the sum of the previous four weeks and update as the year progresses.

Any further information you might need, let me know!

Thanks all :)

Spencer101

Quote:

Originally Posted by ExcelNewbieUK (Post 1606232)

Could you post a sample workbook?

All times are GMT +1. The time now is 11:00 PM.