View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott
 
Posts: n/a
Default COUNTIF question

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?