G
Guest
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?
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?