Sumifs using month ranges

[jsims33]

I'm trying to sum the values in a range (say E2:E10), if the text in a range (D2:D10) matches the text in cell (differentsheet!B110) AND if the date contained in a range (B2:B10) falls in the month of January. How do I do this?

 

[alansidman]

Using XL2BB, provide us with a small sample worksheet.

 

[jsims33]

Thanks, I actually just figured it out. Thanks for the effort.