Forum Discussion
DebraAlt
Apr 29, 2021Copper Contributor
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
Sort By
- Riny_van_EekelenPlatinum Contributor
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.
- DebraAltCopper ContributorThe double quotes did it!!!!!
Thank you!!!