I have a spreadsheet with these data (all of these dates and amounts are arbitrary):
A B
12/1/2015 700
1/7/2016 100
1/13/2016 200
2/5/2016 300
3/19/2016 500
and another column with the first date of each month. I'm trying to sum the data by month/year to get something like this:
E F
12/1/2015 700
1/1/2016 300
2/1/2016 300
3/1/2016 500
Entering the dates into the first column of the pseudo pivot table isn't the problem; it's summing the data by date. In column F, I've tried this:
=ARRAYFORMULA(SUM(IF(AND(MONTH($A$1:$A$5)=MONTH(E1), YEAR($A$1:$A$5)=YEAR(E1)), $B$1:$B$5)))
but this returns all zeros. How do I do this?