Hi Marcelo,
It is close to working but it adding an additional 1, i.e. the count
should be 11 but it shows 12. Thanks

"Marcelo" wrote:

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