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
- Apr 29, 2021
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.
Riny_van_Eekelen
Apr 29, 2021Platinum 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.
- DebraAltApr 29, 2021Copper ContributorThe double quotes did it!!!!!
Thank you!!!