Many thanks guys for the very quick response. Worked perfectly. Sorry it
took me so long to reply, but I wasn't able to verify my e-mail address.


"Ardus Petus" wrote:

=SUMPRODUCT((YEAR(A1:A999)=2006)*(MONTH(A1:A999)=6 )*(G1:G999<""))

HTH
--
AP

"l.shields" a écrit dans le message de
news: ...
Using Excel 2003 I need to count rows where the date in column A is in a
particular month and year and column G is not blank.