Thread: COUNT
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default COUNT

=countif(A1:A100,"0") if numbers can be decimal and less than 1 e.g 0.56

Or

=countif(A1:A100,"=1")

HTH

"Christina Bachman" wrote:

How do I count cells with numbers 1 and greater. My cells are counting the
-. All my cells are showing the - (zero value) but are being counted. Thanks