This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)

I can't get this formula to work for February....etc. I need to use the
same range of cells.

Please help.