Hi,

I have a set of data as follows:

B C
Date Clicks
12-Jun 202
13-Jun 248
14-Jun 340
15-Jun 81
16-Jun 46
17-Jun 250
18-Jun 500

I want to set up a formula for a running total for the last 7 day so that as I add a row of data the running total auto updates.

Thanks