Steve, sorry I couldnt seem to get that to work either. Is there a way to
change a date say 12/1 to one by using an if formula
thanks scott
maybe i am doing something wrong

"SteveG" wrote:


Scott,

A1:A10 as range.


=SUMPRODUCT(--(MONTH(A1:A10)=12))

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=498019