Hi
Trying to figure out if it's possible to repeat the same formula 5 times on a range of cells, and then restart the formula 5 times on the following 5 cells and then again...



E.g.

I have a cell range from A1 to A20

I want the formula to run in B1 to B20

E.g. of how the formula will run over 5 cells:

First in B1: I want: A1 / 2,
Then in B2: A2 / 2 + B1,
Then in B3: A3 /2 + B2,
Then in B4: A4 /2 +B3,
Then in B5: A5/2 +B4.

Then I want the whole shebang to repeat its self over the next 5 cells etc.

Not sure if this is possible?

Jenny