you can just use a countif for this:

=COUNTIF(A1:A10, 1)

would count in the range a1:a10 the number of cells containing the
number 1

or if you need to count lots of numbers, put the number in B1 you want
to count and then you can change it to the new number after:

=COUNTIF(A1:A10, B1)


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=513150