=COUNTIF(A1:A10,4)

Regards,
Paul

--

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