hi Christina,

=contif(a2:a1000,"=1")

hth
regards from Brazil
Marcelo

"Christina Bachman" escreveu:

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