count if greater than

[DebraAlt]

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 

[#2 · Accepted solution]

@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.

[#3]

The double quotes did it!!!!!
Thank you!!!