Retrieve info with different date formats

[tigerzen]

Would like to try and have the column in yellow fill with a formula/function, the monthly summed values come from the table in Columns G&H. Can I please have this in Excel 2019. The challenge is with the 2 different date formats.

Book6
	A	B	C	D	E	F	G	H
2		Date	Amount	Contributions			Date	Contributions
3		1/12/2021	$ 1,000				Feb-22	$ 100
4		1/01/2022	$ 1,500				Feb-22	$ 200
5		1/02/2022	$ 2,500	$450			Feb-22	$ 150
6		1/03/2022	$ 4,000				Apr-22	$ 300
7		1/04/2022	$ 6,000	$300			May-22	$ 200
8		1/05/2022	$ 8,000	$500			May-22	$ 300
9		1/06/2022	$ 12,000
10		1/07/2022	$ 15,000
Sheet1

 

[tigerzen]

Try. In D3 copied down

=SUMPRODUCT($H$3:$H$8*(MONTH($G$3:$G$8)=MONTH($B3))*(YEAR($G$3:$G$8)=YEAR($B3)))

 

[tigerzen]

Thanks kvsrinivasamurthy, that worked! Appreciate your suggestion.