Re: COUNTIF HELP???

Giganews Newsgroups
Subject: Re: COUNTIF HELP???
Posted by:  Bob Phillips (bob.philli…@notheretiscali.co.uk)
Date: Wed, 17 May 2006

=SUMPRODUCT(--(S2:S200="CUSTOMER"),--(MONTH(B2:B200)=5))

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"scott" <sco…@discussions.microsoft.com> wrote in message
news:81E87B9D-525F-420E-9629-FAF39ECD57…@microsoft.com...
> I am trying to count how many times a customer has a discrepancy using a
> COUNTIF formula.
> I have set up:
>
> =COUNTIF(S:S,"CUSTOMER") - where S:S is a column of drop down lists where
> "CUSTOMER" can be selected.
>
> However, I need to have counts per month. I tried to specify the data per
> month like:
>
> =IF(MONTH(B:B)=5,COUNTIF(S:S,CUSTOMER),) - where B:B is a column of dates.
>
> Is this even possible? Do I need to enter my dates as =DATE(2006,5,16)?
>
> Thanks for your time.
> Scott

Replies

None

In response to

COUNTIF HELP??? posted by Scott on Tue, 16 May 2006