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?