Hi Christina sory for the typo error =countif(a2:a1000,"=1")

regards

"Marcelo" escreveu:

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