Rolling total of prior 3 rows including present row

[ramatp30]

Hi All

For one of my use case i need to have 4 quarters sum.For any given row i need to have sum off 3 prior quarters or rows including present row.

 Below excel table will give more information about my usecase.

Any help is much appreciated. 

Quarter	Commencements_Total	RunningTotal(4Rows)
Sep-84	0
Dec-84	0
Mar-85	0
Sep-84	10676	10676
Dec-84	9885	20561
Mar-85	8419	28980
Jun-85	10987	39967
Sep-85	10707	39998
Dec-85	9093	39206
Mar-86	8076	38863
Jun-86	8061	35937
Sep-86	9171	34401

[jasperlch · Accepted solution]

Hi @ramatp30, 

A Mulitle Row Formula tool could do the job well:

[ramatp30]

Yes i got it.

Thanks @jasperich :)