Hi,

Try this but be careful, if there are dates in the range because dates in
Excel are numbers then they could also be counted.

=COUNTIF(A1:A20,"1000")

Mike

"Arvind Mahto" wrote:

Can i pull out the count of more than 1000 out of a range of numbers?
Please help...