Sum by month

SUMIFS(values,dates,">="&A1,dates,"<"&EDATE(A1,1))
The column contains first-of-month dates, formatted to display just the month
Another way to solve this problem is to use the SUMPRODUCT function and the TEXT function.