How to check > or < in a column

[alive15]

Good morning,

I have a column with about 4000 numbers. I want to see how many cells in this column have a value greater than .17.

Thanks,

 

[Fluff]

How about
=COUNTIFS(B:B,">0.17")

 

[alive15]

No, this did not work. See my picture below:

https://pasteboard.co/HRIMbJg.jpg

I have at least two numbers in the picture greater than .17, but it still shows a 0.

 

[Fluff]

There's only one number greater than 0.17
Do you mean greater then or equal to?

 

[alive15]

There's .173 and 1, both greater than .17; but even if there is only one number greater than .17, then I should read a value of "1", not "0" for the entire column. I am just looking for the basic formula. Is there some error with yours?

 

[Fluff]

I thought that the 1 was the result of the formula.
The reason that you are getting 0 is that you have a circular reference.
Either move the formula to another column, or specify the range of data you want to work on like
=COUNTIFS(Q2:Q17,">0.17")

 

[alive15]

I'm unsure what circular reference means, but your new formula worked.

Thanks!

 

[jtakw]

I'm unsure what circular reference means

Hi,

Your formula was in may be Q18, and the formula is Counting the Entire Column Q, so you're telling the formula to Count itself "circular reference".

 

[Fluff]

You're welcome & thanks for the feedback.
A circular reference is when a formula is looking at the cell that contains the formula.
In this case you were looking for any cell in col Q that was greater than 0.17, but as the formula is in col Q it tries to count itself.

 

[alive15]

Thank you.

I have one more question, I have a similar scenario in a column where instead of numbers, I have "Good" or "Reject" and I want to count how many are "Reject". I tried using =COUNTIFS(G13:G798,"Reject"). How can I do this for words? See picture below.

https://pasteboard.co/HRKjXRO.jpg

Thanks,