Maybe this will become clearer after you upload a workbook with some sample data, but I suspect SUMPRODUCT might be your ticket, as in

=SUMPRODUCT(--MONTH(DateRange)=MONTH(CellValue)),SumRange)

or something like that.

Click "Go Advanced" below and then the paper clip icon to upload a (small!) data sample that illustrates what you want to achieve.

cheers