last post is not correct!
=SUMPRODUCT((INT(A1:A11)0)*1) ' for the integer count

this will count all numbers as integers


--
schuurke28
------------------------------------------------------------------------
schuurke28's Profile: http://www.excelforum.com/member.php...o&userid=15818
View this thread: http://www.excelforum.com/showthread...hreadid=273137