You could try

=SUMPRODUCT(ISTEXT(A1:A100)*1)

Which would count all the non numeric values which is what i guess you
want

You could of course use data,validation and set a condition to stop
them being entered in the first place, whole number if they are always
whole numbers

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=507704