Please help

[scott]

I would like to be able to return how many times a customer has had a problem
with our service per month.

My dates are entered as =date(2006,5,31) in column B.

I want to count how many times the text from a drop down list = "CUSTOMER"
in column S.

Could I use a COUNTIF to return the number of times "CUSTOMER" appeared in
column S during the month of MAY?

Your help is appreciated!!!

[Bob Phillips]

=SUMPRODUCT(--(S1:S100="CUSTOMER"),--(MONTH(B1:B100)=5))

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)

"scott" <scott@discussions.microsoft.com> wrote in message
news:E76D5FA1-AD1E-4166-A93A-B46B44FD7AE1@microsoft.com...
> I would like to be able to return how many times a customer has had a
problem
> with our service per month.
>
> My dates are entered as =date(2006,5,31) in column B.
>
> I want to count how many times the text from a drop down list = "CUSTOMER"
> in column S.
>
> Could I use a COUNTIF to return the number of times "CUSTOMER" appeared in
> column S during the month of MAY?
>
> Your help is appreciated!!!
>
>