Calculate sum based on date to show as this month

[maybeso]

Hi team, I want to have a rolling total of 'This month figures' and 'Next month figures' based on dates in one column and corresponding amounts. So in column B there is a date, Column C an amount. If the date is within 'this month' I want it to add the column C figure, same for next month. Basically I am looking to get expected figures for this month and next month displayed at the top of the spreadsheet, without having to change the formula each month. I hope that makes sense. Thankful for any guidance.

 

[etaf]

for this month
=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),0))

next month
=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),1))

Various.xlsx
	B	C	D	E	F	G
1	date	amount			This Month	next Month
2	1/1/22	1			120	600
3	1/10/22	2
4	1/19/22	3
5	1/28/22	4
6	2/6/22	20
7	2/15/22	40
8	2/24/22	60
9	3/5/22	100
10	3/14/22	200
11	3/23/22	300
Sheet14

Cell Formulas
Range	Formula
F2	F2	=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),0))
G2	G2	=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),1))

 

[maybeso]

for this month
=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),0))

next month
=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),1))

Various.xlsx
	B	C	D	E	F	G
1	date	amount			This Month	next Month
2	1/1/22	1			120	600
3	1/10/22	2
4	1/19/22	3
5	1/28/22	4
6	2/6/22	20
7	2/15/22	40
8	2/24/22	60
9	3/5/22	100
10	3/14/22	200
11	3/23/22	300
Sheet14

Cell Formulas
Range	Formula
F2	F2	=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),0))
G2	G2	=SUMIFS(C2:C11,B2:B11,">="&DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(1)),B2:B11,"<="&EOMONTH(TODAY(),1))

Thank you so much, this is awesome!! Worked perfectly!

 

[etaf]

you are welcome