If you change =1 to =2 and your col B is properly formatted dates, it will
work for Feb to sum col D
This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)
Try , instead of *
This is what I am using: =sumproduct((month(B5:B412)=1),D5:D412)

--
Don Guillett
SalesAid Software

"RGlade" wrote in message
...
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.