What is wrong with formula?

[Guest]

A B C
8/1/06 8/1/06 2
8/2/06 8/2/06 1
8/3/06 8/3/06 2
8/3/06
8/1/06

I need a formula to count how many dates in the list are for 8/1, 8/2, etc.
I tried COUNTIF(A1:A5,=b1) and get 0 value

 

[Guest]

=COUNTIF(A1:A5,B1)

You don't need the =B1, it is just B1

 

[Don Guillett]

Or, if you insist on using = try "="&b1

 

[shail]

Hi,

=COUNTIF(A$1:A$5,B1)

should work for you

Thanks

Shail