Calculate last 12 months sales figures

[davids4500]

Hi

I have the dates in column A (running from (A2)10/01/2019 to (A85) 01/08/2024) A86 will become 01/09/2024 etc
I have the sales figures in Column B
I want to calculate the total of the sales figures for the last 12 months (from today)
which i would presume that as the next month starts, the calculation would include the latest month and drop off the what is now the 13th month.
I understand that using =SUMIFS is the formula.
I will appreciate your help.
Kindest regards David

 

[MARK858]

Have a look at the link below, just swap the column A and B over (hold your mouse over the cells in column C for the minus one year formula rather than the -365 days formula [or copy the table into your excel])

Rolling totals for a 365 day period

I have a project that requires that I have a spreadsheet to track participation per day over a rolling 365 day period. In essence, an individual cannot exceed 90 days total participation over a 365 day period. I built a spread sheet with the individual month on a row and individual days in...

www.mrexcel.com

 

[MARK858]

Probably easier just to put the table for a straight 12 months from today (formula in D2, adjust the ranges to suit)

Book1
	A	B	C	D
2	18/08/2023	6		47
3	26/08/2023	10
4	03/09/2023	8
5	11/09/2023	6
6	19/09/2023	5
7	27/09/2023	10
8	05/10/2023	1
9	13/10/2023	4
10	21/10/2023	2
11	29/10/2023	5
12	06/11/2023	9		47
13	14/11/2023	2
14	22/11/2023	3
Sheet1

Cell Formulas
Range	Formula
D2	D2	=SUMIFS($B$2:$B$85,$A$2:$A$85,"<="&TODAY(),$A$2:$A$85,">="&DATE(YEAR(TODAY()),MONTH(TODAY())-12,DAY(TODAY())))
D12	D12	=SUM(B5:B14)

 

[MARK858]

Or a slightly shorter version

=SUMIFS($B$2:$B$85,$A$2:$A$85,"<="&TODAY(),$A$2:$A$85,">="&EDATE(TODAY(),-12))

 

[davids4500]

=SUMIFS($B$2:$B$85,$A$2:$A$85,"<="&TODAY(),$A$2:$A$85,">="&EDATE(TODAY(),-12))

Dear Mark858. Very good, You are a gem. Much appreciated. works perfectly

 

[MARK858]

You're welcome