I have a table (lets say 100 rows):
Column A has a 6 digit code
Column B has a month number (1-12)
Column C has a date
Column D has a value

I'm trying to construct the formula so that I can add up all the values for dates that fall within a month, for the sake of example Jan-17 i.e. 42736 and 42766.
It's the range piece that I don't know how to syntax.

I guess it would look like =SUMPRODUCT((A1:a1000=6 digit code)*(b1:b1000=Month Number)*(??????????)*(D1:D1000)

Can anyone help with the ???????

Thanks in advance