Home

percentages

%3CLINGO-SUB%20id%3D%22lingo-sub-741328%22%20slang%3D%22en-US%22%3Epercentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741328%22%20slang%3D%22en-US%22%3E%3CP%3Ei'm%20trying%20to%20count%20the%20number%20of%20percentage%20values%20in%20a%20range%20that%20are%20above%20or%20equal%20to%20a%20certain%20percentage%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-741328%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
dbyrne
Occasional Visitor

i'm trying to count the number of percentage values in a range that are above or equal to a certain percentage 

1 Reply
If the percentage range is in Column A and the certain percentage is in B2, you can use COUNTIF, like this:
=COUNTIF(A:A,
“>=“&
B2)
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies