Thread: COUNT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default COUNT

By not posting your formula, you don't give us anything to correct.

Try this:

For a range of numbers in A1:A100

This formula returns the count of cell values greater than 1:
B1: =COUNTIF(A1:A100,"1")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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