software

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,quot;CUSTOMERquot;)

S:S is a column in which I have a drop down list where quot;CUSTOMERquot; 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=quot;CUSTOMERquot;))

HTH
--
AP

quot;scottquot; gt; a écrit dans le message de news:
...
gt;I would like to use a COUNTIF formula to count how many times a customer
gt;has
gt; a discrepency per month. I have set one up for my whole worksheet as :
gt;
gt; =COUNTIF(S:S,quot;CUSTOMERquot;)
gt;
gt; S:S is a column in which I have a drop down list where quot;CUSTOMERquot; can be
gt; selected.
gt;
gt; This works fine, however, I would like to specify the information per
gt; month.
gt; I am unsure how to set up a range to look at within my B:B column (date
gt; column).
gt;
gt; My dates are set up as 3/1/2006. Could I return only information for the
gt; month of March, April, May etc?