Ask Your Question

How do I create 12 month rolling total?

asked 2018-04-04 12:56:09 +0200

mcgulliver gravatar image

I am self-employed and want to stay under the VAT threshold so I need to keep an eye on my 12 month rolling total of earnings. I have a spreadsheet set up with 'month' in column A, 'earnings' in column B and I'd like column C to be rolling total for the previous 12 moths but I cannot for the life of me find a formula that allows me to see a total for the 12 months in any given month. Can anyone help please?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-04-04 13:49:10 +0200

Lupp gravatar image

updated 2018-04-04 13:49:41 +0200

It is not exactly easy for me to describe a solution (except in very general terms). Therefor I preferred to create this attached demo.
It handles two different assumptions concerning the 12-month-period. Firstly: The period must start with a first-day-of-month. Secondly: The period can start with any day.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-04 12:56:09 +0200

Seen: 211 times

Last updated: Apr 04 '18