"Domenic" wrote in message
...
Try...

=SUMPRODUCT(--(MONTH(A1:A10)=6),--(YEAR(A1:A10)=2003))

or =SUMPRODUCT(--(TEXT(A1:A6,"mmyyyy")="062003"))

just an alternative <g