SOLVED

count if greater than

%3CLINGO-SUB%20id%3D%22lingo-sub-2307953%22%20slang%3D%22en-US%22%3Ecount%20if%20greater%20than%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2307953%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20find%20how%20many%20cells%20contain%20the%20value%20of%20more%20than%202%3C%2FP%3E%3CP%3Ethe%20total%20continues%20to%20come%20up%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3Dcountif(E2%3AE51%2C'%26gt%3B2')%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecould%20it%20be%20because%20the%20value%20in%20E%20is%20a%20formula%20of%20%3DC%2BD%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2307953%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2308033%22%20slang%3D%22en-US%22%3ERe%3A%20count%20if%20greater%20than%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308033%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1040958%22%20target%3D%22_blank%22%3E%40DebraAlt%3C%2FA%3E%26nbsp%3BThe%20formula%20should%20not%20work%20at%20all%20with%20the%20single%20quotes.%20Try%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DCOUNTIF(E2%3AE51%2C%22%26gt%3B2%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20make%20sure%20that%20the%20numbers%20in%20E2%3AE51%20are%20real%20numbers%2C%20Not%20just%20texts%20looking%20like%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2308044%22%20slang%3D%22en-US%22%3ERe%3A%20count%20if%20greater%20than%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308044%22%20slang%3D%22en-US%22%3EThe%20double%20quotes%20did%20it!!!!!%3CBR%20%2F%3EThank%20you!!!%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
best response confirmed by DebraAlt (New Contributor)
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.

 

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