You're the fastest shooter West of Colorado, Bob!

Cheers,
--
AP

"Bob Phillips" a écrit dans le message de news:
...
oops, mis-read it. I see that now seeing Ardus' response.

--
HTH

Bob Phillips

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

"Bob Phillips" wrote in message
...
=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.