A row of values
 

I have a row of 50 numericlical values. Some are positive other
negative.
Is there any way other than manually counting, I can determine
how many values are say greater than 4? Or how many values are
less than or equal to -2?
Any formula help will be much appreciated.
Thanks
Skip

A row of values
 

You would use the COUNTIF function. For your two questions...

=COUNTIF(1:1,"4")

=COUNTIF(1:1,"<=-2")

--
Rick (MVP - Excel)


"Skip" wrote in message
...
I have a row of 50 numericlical values. Some are positive other
negative.
Is there any way other than manually counting, I can determine
how many values are say greater than 4? Or how many values are
less than or equal to -2?
Any formula help will be much appreciated.
Thanks
Skip

A row of values
 

On Oct 8, 3:57*pm, "Rick Rothstein"
wrote:
You would use the COUNTIF function. For your two questions...

=COUNTIF(1:1,"4")

=COUNTIF(1:1,"<=-2")

--
Rick (MVP

Rick many thanks. One more question can I enter a cell number rather
than a value like 4 or -2, and
have the formula countif according to the value in the cell?

A row of values
 

Assuming A2 has the value 4 in it...

=COUNTIF(1:1,""&A2)

and if A3 has the value -2 in it...

=COUNTIF(1:1,"<="&A3)

--
Rick (MVP - Excel)


"Skip" wrote in message
...
On Oct 8, 3:57 pm, "Rick Rothstein"
wrote:
You would use the COUNTIF function. For your two questions...

=COUNTIF(1:1,"4")

=COUNTIF(1:1,"<=-2")

--
Rick (MVP

Rick many thanks. One more question can I enter a cell number rather
than a value like 4 or -2, and
have the formula countif according to the value in the cell?