Maybe you could use something like:

=SUM(IF(ISNUMBER(D2:D15),--(MONTH(D2:D15)=1)))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column



Gohan51D wrote:
>
> The formula seems to work but I didn't mention that the column of dates
> also contains text. When I remove the text the formula works great but
> once the text is entered I get #VALUE!, how can I ignore all text.
>
> Gohan51D
>
> --
> Gohan51D
> ------------------------------------------------------------------------
> Gohan51D's Profile: http://www.excelforum.com/member.php...o&userid=32274
> View this thread: http://www.excelforum.com/showthread...hreadid=521940

--

Dave Peterson