Alternate to FILTER function in old version of Excel

[sharshra]

I´m using Filter function to get the correct results from the table below. But, I have to get the same result in an older version of excel, which doesn´t support Filter function. Any suggestions on how can I get the same result?

Also, I would like to know how can I write a single cell formula to get the same result in Office 365 version. Can the experts in this forum help please?

Source table:

excel problems.xlsx
	B	C	D
2	#	date	amount
3	1	5-nov-23	10
4	2	2-dic-23	20
5	3	3-dic-23	5
6	4	3-ene-24	12
7	5	8-feb-24	21
Sheet2

Output table:

excel problems.xlsx
	G	H
2	month	amount
3	oct-23
4	nov-23	10
5	dic-23	25
6	ene-24	12
7	feb-24	21
8	mar-24
9	abr-24
10	may-24
11	jun-24
12	jul-24
Sheet2

Cell Formulas
Range	Formula
H3:H12	H3	=IFERROR(SUM(FILTER($D$3:$D$12,TEXT($C$3:$C$12,"mmm-aa")=TEXT(G3,"mmm-aa"))),"")

 

[Fluff]

How about

=SUMIFS(D:D,C:C,">="&G3,C:C,"<="&EOMONTH(G3,0))

and for all the dates

=SUMIFS(D:D,C:C,">="&G3:G12,C:C,"<="&EOMONTH(+G3:G12,0))

 

[sharshra]

Perfect!!! Thanks, @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.