Formula help Need SUMIFS for a column with starting numbers

[zone709]

HI i need to total column J off of Column D reference.

So i need to go off of column D with first 2 numbers.

Column D has dates in them. So lets say i want to Sum total for July. I want to get sum from the date starting with 07 as the dates go down like this 07/02/2024 or 07/09/2024 etc.

Then next month i can change the formula for column D to 08 for August.

 

[ExcelToDAX]

Definitely an easier way, but how about:

=SUM(FILTER(J:J,IFERROR(MONTH(IF(D:D="","",D:D)),"")=7))

 

[RobP]

Or maybe something like this if you want to define your month in a cell up front ..

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Month:	10
2	Result:	110
3				01/10/2024						10
4				02/10/2024						5
5				03/10/2024						10
6				04/10/2024						12
7				05/10/2024						15
8				06/10/2024						5
9				07/10/2024						10
10				08/10/2024						20
11				09/10/2024						23
12				10/11/2024						14
13				11/11/2024						18
14				12/11/2024						22
15				13/11/2024						55
16				14/11/2024						13
17				15/11/2024						5
18				16/11/2024						9
19				17/11/2024						11
20				18/11/2024						16
21				19/11/2024						18
22				20/11/2024						27
23
Sheet1

Cell Formulas
Range	Formula
B2	B2	=SUM(FILTER(J3:J22,MONTH(D3:D22)=B1))

 

[zone709]

Definitely an easier way, but how about:

=SUM(FILTER(J:J,IFERROR(MONTH(IF(D:D="","",D:D)),"")=7))[/CO
[/QUOTE]

Perfect thanks guys