I would like to use a COUNTIF formula to count how many times a customer has
a discrepency per month. I have set one up for my whole worksheet as :

=COUNTIF(S:S,"CUSTOMER")

S:S is a column in which I have a drop down list where "CUSTOMER" can be
selected.

This works fine, however, I would like to specify the information per month.
I am unsure how to set up a range to look at within my B:B column (date
column).

My dates are set up as 3/1/2006. Could I return only information for the
month of March, April, May etc?

Hi, Scott

=SUMPRODUCT(--(MONTH(B1:B65536)=3);--(S1:S65536="CUSTOMER"))

HTH
--
AP

"scott" a écrit dans le message de news:
...
I would like to use a COUNTIF formula to count how many times a customer
has
a discrepency per month. I have set one up for my whole worksheet as :

=COUNTIF(S:S,"CUSTOMER")

S:S is a column in which I have a drop down list where "CUSTOMER" can be
selected.

This works fine, however, I would like to specify the information per
month.
I am unsure how to set up a range to look at within my B:B column (date
column).

My dates are set up as 3/1/2006. Could I return only information for the
month of March, April, May etc?