Use multiple criteria with COUNTIF: between dates and not blank
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.
|