How can I sum amounts from a different sheet onto a new sheet if the months are the same?

[statiCat]

I have 2 sheets in a workbook that look like:

Sheet1:

amount	date
45	3/5/2018
65	3/8/2018
6	4/5/2018
342	4/8/2018
45	5/5/2018
654	5/8/2018
2	6/1/2018

<colgroup><col width="64" span="2" style="width: 48pt;"></colgroup><tbody>
</tbody>

Sheet2:

6/2018	<JunSum>
5/2018	<MaySum>
4/2018	<Apr Sum>
3/2018	<MarSum>

<colgroup><col style="width: 68px"></colgroup><colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>
</tbody>

I would like Sheet2 column B to have the sum of all amounts in Sheet 1 where the months match for Sheet1 column B/Sheet2 column A. I have tried a couple things including:

SUMIFS(Sheet1!$A:$A,MONTH(Sheet1!$B:$B),MONTH(B3))

<colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>
</tbody>

SUMPRODUCT((MONTH(Sheet1!$B:$<wbr style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif; font-size: medium;">B)=MONTH(A3))*(YEAR(Sheet1$B:$<wbr style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif; font-size: medium;">B)=YEAR(A3))*(Sheet1$A:$A))


but they are not working. Any ideas on how to make this work?

 

[AhoyNC]

Assuming your dates in Sheet2 are actual dates (6/1/18) formatted as m/yyy then try:

Excel Workbook
	A	B
1	Date	Total
2	6/2018	2
3	5/2018	699
4	4/2018	348
5	3/2018	110
Sheet2

Excel Workbook
	A	B
1	amount	date
2	45	3/5/2018
3	65	3/8/2018
4	6	4/5/2018
5	342	4/8/2018
6	45	5/5/2018
7	654	5/8/2018
8	2	6/1/2018
Sheet1