Use multiple criteria with COUNTIF: between dates and not blank

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

Cheers,
--
AP

"Bob Phillips" <bob.NGs@somewhere.com> a écrit dans le message de news:
uOcfDX5kGHA.3816@TK2MSFTNGP02.phx.gbl...
> 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" <bob.NGs@somewhere.com> wrote in message
> news:%23eQQr34kGHA.4212@TK2MSFTNGP03.phx.gbl...
>> =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" <l.shields@discussions.microsoft.com> wrote in message
>> news:31C32C19-9C42-4F23-AEBE-93676CAB7128@microsoft.com...
>> > 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.
>>
>>
>
>

I'm actually East of Colorado!

--
HTH

Bob Phillips

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

"Ardus Petus" <ardus.petus@laposte.net> wrote in message
news:Oi8jEj5kGHA.1936@TK2MSFTNGP04.phx.gbl...
> You're the fastest shooter West of Colorado, Bob!
>
> Cheers,
> --
> AP
>
> "Bob Phillips" <bob.NGs@somewhere.com> a écrit dans le message de news:
> uOcfDX5kGHA.3816@TK2MSFTNGP02.phx.gbl...
> > 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" <bob.NGs@somewhere.com> wrote in message
> > news:%23eQQr34kGHA.4212@TK2MSFTNGP03.phx.gbl...
> >> =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" <l.shields@discussions.microsoft.com> wrote in message
> >> news:31C32C19-9C42-4F23-AEBE-93676CAB7128@microsoft.com...
> >> > 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.
> >>
> >>
> >
> >
>
>