COUNT
 

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

COUNT
 

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

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

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

COUNT
 

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

COUNT
 

OOPs....you wanted 1 inclusive:

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

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

XL2002, WinXP


"Ron Coderre" wrote:

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

COUNT
 

It is close but it adding an addition 1, i.e. the count should be 10 but
gives me 11.

"Ron Coderre" wrote:

OOPs....you wanted 1 inclusive:

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

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

XL2002, WinXP


"Ron Coderre" wrote:

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

COUNT
 

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

COUNT
 

It is close but it adding an addition 1, i.e. the count should be 10 but
gives me 11.

"Toppers" wrote:

=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

COUNT
 

It worked!!!!!! Thank you so much....I had a formula problem.....

"Ron Coderre" wrote:

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

COUNT
 

It worked!!!!!! Thank you so much...I had a formula problem....

"Marcelo" wrote:

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

COUNT
 

MAke sure in the range you are not including the cell that the formula is in

"Christina Bachman" <Christina wrote in
message ...
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

COUNT
 

Thank you....it worked.....I had a formula problem....

"Toppers" wrote:

=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