=SUMPRODUCT(--(G2:G20<""),--(MONTH(A2:A20)=1))

for January

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

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

"l.shields" wrote in message
...
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.