SUMIFS against a Month & Year

[Steve 1962]

Hi

I'm looking to perform a SUMIFS to lookup a column of dates (column A) against a month-year value (column D).

I require the SUMIFS formula to reside in cells E2 & E3 and return the answers as provided in the example.

Thanks

SH

Book1
	A	B	C	D	E
1	Date	Value		Month	Answer
2	26/02/2023	10		1/02/2023	18
3	27/02/2023	5		1/03/2023	22
4	28/02/2023	3
5	1/03/2023	6
6	2/03/2023	4
7	3/03/2023	4
8	4/03/2023	8
Sheet2

Cell Formulas
Range	Formula
E2	E2	=SUM(B2:B4)
E3	E3	=SUM(B5:B8)

 

[kevin9999]

Book1
	A	B	C	D	E
1	Date	Value		Month	Answer
2	26/02/2023	10		1/02/2023	18
3	27/02/2023	5		1/03/2023	22
4	28/02/2023	3
5	1/03/2023	6
6	2/03/2023	4
7	3/03/2023	4
8	4/03/2023	8
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=SUMIFS($B$2:$B$8,$A$2:$A$8,">="&D2,$A$2:$A$8,"<="&EOMONTH(D2,0))

 

[Steve 1962]

Hey thanks very much Kevin.

All good now.

Keep well.

 

[kevin9999]

Hey thanks very much Kevin.

All good now.

Keep well.

Good to hear

 

[bebo021999]

Another way: use "02-2023" (mm-yyyy format) to identify

=SUMPRODUCT((TEXT($A$2:$A$8,"MM-YYYY")=TEXT(D2,"MM-YYYY"))*$B$2:$B$8)