COUNT FORMULA

[ebraun]

I have in a column 300 rows each row with other numbers for example "a1" 2 "a2" 4 I need to know how many "2" i have, Is there a way.

P.S. I don't want to change the sort

Please help

Thanks a million

 

[lenze]

In a blank cell, enter
=COUNTIF(A:A,2)to count the number of 2's in column A.

 

[ebraun]

Thank you it works fine

 

[ebraun]

This works only on #'s what about names ?

 

[lenze]

=COUNTIF(A:A,"name")

 

[ebraun]

It works by the number only not by the name, Is there a special format ?

Thanks

 

[lenze]

It should work. See Example. Note that it is not case sensitive.

Book1
	A	B	C	D
3	Brown		2
4	Smith
5	Brown		2
6	Jones
7	Smith		3
8	Brown
9	Johnson		1
10	Taylor
11	Jones
Sheet1

 

[ebraun]

Thank you