count only certain cells
 

how do i count cells with a specific value in them... for ex., in the list
below i would like to count the cells with number 4 in the... =3
4
4
4
5
5
5
2
2

count only certain cells
 

See your other post.

--

"Robert-Alpha" wrote in message
...
how do i count cells with a specific value in them... for ex., in the list
below i would like to count the cells with number 4 in the... =3
4
4
4
5
5
5
2
2

count only certain cells
 

use the countif function
i.e. =COUNTIF(A1:A10,4)


On Jun 11, 3:53 pm, Robert-Alpha
wrote:
how do i count cells with a specific value in them... for ex., in the list
below i would like to count the cells with number 4 in the... =3
4
4
4
5
5
5
2
2