=COUNTIF(A1:A15,B1) this works for a specific range


=COUNTIF(A:A,B1) this is for a specific column


Place this formula in B2
B1 you will enter the number you want counted


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528989