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:

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width: 48pt;"></colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]amount[/TD]
[TD="width: 64, bgcolor: transparent"]date[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]45[/TD]
[TD="bgcolor: transparent, align: right"] 3/5/2018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]65[/TD]
[TD="bgcolor: transparent, align: right"]3/8/2018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent, align: right"]4/5/2018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]342[/TD]
[TD="bgcolor: transparent, align: right"]4/8/2018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]45[/TD]
[TD="bgcolor: transparent, align: right"]5/5/2018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]654[/TD]
[TD="bgcolor: transparent, align: right"]5/8/2018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]6/1/2018[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2:

<colgroup><col style="width: 68px"></colgroup><colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>
[TD="bgcolor: transparent, align: right"] 6/2018 [/TD]
[TD="bgcolor: transparent"] <JunSum> [/TD]

[TD="bgcolor: transparent, align: right"] 5/2018 [/TD]
[TD="bgcolor: transparent"] <MaySum> [/TD]

[TD="bgcolor: transparent, align: right"] 4/2018 [/TD]
[TD="bgcolor: transparent"] <Apr Sum> [/TD]

[TD="bgcolor: transparent, align: right"] 3/2018 [/TD]
[TD="bgcolor: transparent"] <MarSum> [/TD]

</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:


[TABLE="width: 64"]
<colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]SUMIFS(Sheet1!$A:$A,MONTH(Sheet1!$B:$B),MONTH(B3))[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
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