Use

=SUMPRODUCT((MONTH(C5:C33)=1)*(M5:M33))





"RayG" wrote in message
...
HI,

I need to sum a colum of numbers in cells M5:M33 if it is between the
dates
1/1/05 and 1/31/05 dates are in cells C5:C33.
In other words in January.

THANKS