Sum if in the same month/year

[joannelittell]

Hello
I searched the boards but was unable to find the solution Im seeking.

I need to find a formula that sums up all the amounts that occur per month/year.

sum by month.xlsx

[ChemistB]

=SUMIFS($B$1:$B$224, $A$1:$A$224, ">="&E1, $A$1:$A$224, "<="& EOMONTH(E1,0))
copied down

Another option, use Pivot tables and group by month and year.

[joannelittell]

perfect! thanks for your quick response.