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

  • Thread starter Thread starter sox
  • Start date Start date
S

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
 
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
 
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.
 
Back
Top