A row of values

[Skip]

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

 

[Rick Rothstein]

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

=COUNTIF(1:1,">4")

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

 

[Skip]

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

=COUNTIF(1:1,">4")

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

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?

 

[Rick Rothstein]

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)

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

=COUNTIF(1:1,">4")

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

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?