sumproduct() formula construction

[Bozo]

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

[Jonmo1]

Perhaps

=SUMPRODUCT((A1:a1000=6 digit code)*(Month(b1:b1000)=Month Number)*(D1:D1000))

Text values in B will cause this to error, so you might skip the Header Row 1
And blanks will be considered January, so may need to add a criteria for B<>""

[Bozo]

Yes, I was forgetting about the header row, good point.
Can you expand on this criteria you mentioned - how would that look within the sumproduct() formula? Apologies for my ignorance, I'm new to this formula.

[Jonmo1]

=SUMPRODUCT((A2:a1000=6 digit code)*(Month(b2:b1000)=Month Number)*(D2:D1000)*(b2:b1000<>""))

That last criteria is only needed IF you have blank cells in column B, AND you're using 1 (for January) as the Month Number

[Bozo]

Thanks for the information, that's great. One last question, if I wanted to sum the values based on two dates that were in different months, let's say between 1/15/2017 and 2/15/2017 (42750 & 42781 respectively), how would I need to change the formula?

[Jonmo1]

Try
=SUMPRODUCT((A2:a1000=6 digit code)*(c2:c1000>=42750)*(c2:c1000<=42781)*(D2:D1000))

[Tony Valko]

Use cells to hold the criteria...

F2 = 6 digit code
G2 = start date
H2 = End date

Then:

=SUMIFS(D2:D1000,A2:A1000,F2,C2:C1000,">="&G2,C2:C1000,"<="&H2)

[Bozo]

Jonmo1, I think you've cracked it for me, this looks like the solution. I'm very grateful for your input and advice.
Tony - your solution works too.
Gentlemen, thank you both.

[Jonmo1]

You're welcome.

[Tony Valko]

You're welcome. Thanks for the feedback!