Forum Discussion
Solved
count if greater than
I am attempting to find how many cells contain the value of more than 2
the total continues to come up 0
=countif(E2:E51,'>2')
could it be because the value in E is a formula of =C+D
DebraAlt The formula should not work at all with the single quotes. Try this:
=COUNTIF(E2:E51,">2")and make sure that the numbers in E2:E51 are real numbers, Not just texts looking like numbers.
2 Replies
DebraAlt The formula should not work at all with the single quotes. Try this:
=COUNTIF(E2:E51,">2")and make sure that the numbers in E2:E51 are real numbers, Not just texts looking like numbers.
- The double quotes did it!!!!!
Thank you!!!
