Percent of a number from a total number

Actionbot08

New Member
Joined
May 9, 2019
Messages
7
Hello,

I am trying to figure out how to calculate a percentage by taking a total number and figuring out what percent of it is another number.

Example:

31
20
19
17
15
15
15
14
14
14
14
13
13
13
13
13
13
13
13
12

<colgroup><col width="56" style="width:42pt"> </colgroup><tbody>
</tbody>

From this example, I need to give a total # of rows (20) and find what percent are 14 or higher (11) - Normally I can just do that math.. But in Excel, I can't figure out how to get the total rows with figures in them and have it figure out how many are a number or higher.

Any help would greatly be appreciated. I'm a novice at Excel but learning day by day.

Thank you,
Joe
 

Actionbot08

New Member
Joined
May 9, 2019
Messages
7
If my math is right, 11 if 55% of 20.



Am I doing something wrong?
 

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
648
You need to reference A2:A21 instead of A1:A20 as A1 is your header row
Yes 55% of 20 is 11
 

Actionbot08

New Member
Joined
May 9, 2019
Messages
7
Nevermind. :) Got it all handled. Thank you guys for the quick replies! Fastest help I ever got on Excel questions from ANY board! Thumbs up!
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top