Try

=SUMPRODUCT(--(YEAR(F2:F174)=2006),--(MONTH(F2:F174)=7))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jennifer1960" wrote in message
...
Using =HLOOKUP(999999999999,F2:AC2,1,1) I am obtaining a last date entered
in
E2.
Must type date in DD/MM/YYYY format.

To add how many time a date (by month appears) Im using
=COUNTIF(F2:F174,"*.7.2006")

It appears to me a conflict of date formats - just not sure how to change
so
both formulars read. Any Assistance?