We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How do I create 12 month rolling total? [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-04 21:02:15.426025

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

Question Tools

1 follower


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

Seen: 349 times

Last updated: Apr 04 '18