Multiple date based SUMPRODUCT failing

I have the the need to show the sum of the product of sheet 2 on sheet 1 if several conditions are met.

The formula is working except for the first array:

=SUMPRODUCT(--(Bid_Circuits=$A2),--(Bid_Week_End=MONTH(D2)),--(Bid_Week_End=YEAR(D2)),--(Bid_Completed))

When I use XL's evaluate feature, XL seems to find the proper data yet returns #VALUE!

I have no idea where to go from here & I would greatly appriciate any help.