Countif and dates

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a 20,000 entry spreadsheet that contains dates in this format
07/04/2010, As you can imagine there are quite a few of these entries
for each month. I want to count the number of them for a particular
month. I can't seem to use wildcards for some reason and cant find the
answer why on the net.

There formula that I would expect to work goes like this: - (ps I am
looking for all the March(03) entries in the column A)
=COUNTIF(A:A, "*/03/*")

This always returns a 0 and I can't see why?

In an ideal would I would like this to count the above AND also
countains the word EXAMPLE in the F:. I think the second part is much
easier than the first as I can easily use wildcards for searching for
things on their own.

Any help would be greatly appreciated as I am confused.com!

Scott
 
I have a 20,000 entry spreadsheet that contains dates in this format
07/04/2010, As you can imagine there are quite a few of these entries
for each month. I want to count the number of them for a particular
month. I can't seem to use wildcards for some reason and cant find the
answer why on the net.

There formula that I would expect to work goes like this: - (ps I am
looking for all the March(03) entries in the column A)
=COUNTIF(A:A, "*/03/*")

This always returns a 0 and I can't see why?

In an ideal would I would like this to count the above AND also
countains the word EXAMPLE in the F:. I think the second part is much
easier than the first as I can easily use wildcards for searching for
things on their own.

Any help would be greatly appreciated as I am confused.com!

Scott
Click to expand...


maybe =COUNTIF(A:A,"month=03")
 
Excel sees dates as serial values and not how your dates are formatted. I
would use =Month(A1) on your dates then COUNTIF(B1:B100,3)
 
Back
Top