Thread: counts
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default counts

Try this:

=COUNTIF(A:A,"1000")

assuming your numbers are in column A.

Hope this helps.

Pete

On May 23, 3:22*pm, Arvind Mahto
wrote:
Can i pull out the count of more than 1000 out of a range of numbers?
Please help...