What is wrong with formula?
 

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

What is wrong with formula?
 

=COUNTIF(A1:A5,B1)

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


"TMF in MN" wrote:

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

What is wrong with formula?
 

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


--
Don Guillett
SalesAid Software

"Allllen" wrote in message
...
=COUNTIF(A1:A5,B1)

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


"TMF in MN" wrote:

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

What is wrong with formula?
 

Hi,

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

should work for you

Thanks

Shail


TMF in MN wrote:
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