Counting how many times a number appears in a list?(EXCEL)

[sox]

hi, got a small problem in excel, situation as below:

grade
1
2
3
1
2
1
2
3
4
1
1

what formula do I use to count how many times (e.g) 1 appears in th
list? I thought I could do it with the Count function but haven
managed to.

Cheers

 

[DNF Karran]

The "countif" formula should do!

Dunca

 

[Peo Sjoblom]

=COUNTIF(A1:A15,1)

 

[DDM]

sox, =COUNTIF(A2:A12,1). Substitute your range.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[JMay]

Here's a neat formula ( as a check against your original request)
=SUM(1/COUNTIF(A3:A12,A3:A12))<<Chg Range to your Range
which will give you the number of unique numbers in your range.
must be array-entered by not using just Enter, but rather
Control+Shift+Enter
Doing so will place the { } characters around. << Such characters CANNOT
be
entered at the keyboard..
HTH
JMay

 

[coldgin00]

Okay, but what if your numbers are up to 14 digits long? Would the same formula work and what numbers would be changed. As I see it, you are telling it to look for a particular number, I.E. 1 or is it counting all like numbers reqardless.