Tallying data

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I need to count the number of instances a certain value
appears in a range of cells.

For example, I have data that are numbers in a column say
A2:A100. I need to know how many time the number 13
appears in that column.

How do I do this?
 
You need the Countif function

=countif(range,criteria)

So yours would be =countif(A2:A200,13)

Hope this helps

Judit
 
Back
Top