A row of values

S

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
 
R

Rick Rothstein

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

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

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

Skip

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

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

=COUNTIF(1:1,"<=-2")
Click to expand...

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?
 
R

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")
Click to expand...

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with formula for finding last greater than/less than or equal to value 2
Sliding Commission Formula 2
formula for arriving net difference 0
return multiple values when within range (greater than and less than) 11
Problems created by Recent updates to Outlook 365 0
Countifs bites again 4
Excel Countif Function - Calculating Between Two Sets of Values 3
Is there a way to change the color 3

Top