Because you are not using the formula correctly. This function only has
2 arguments, the first is the range, and the second is the criteria

Hence this will count all the 1's in the range

=countif(j2:j20,"1")

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561912