counts

[Arvind Mahto]

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

 

[Mike H]

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

 

[Pete_UK]

Try this:

=COUNTIF(A:A,">1000")

assuming your numbers are in column A.

Hope this helps.

Pete

 

[JE McGimpsey]

If I understand you correctly:

=COUNTIF(range, ">1000")