try
=sumproduct((month(c5:c33)=1)*m5:m33)

--
Don Guillett
SalesAid Software

"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