# Percent of a number from a total number

#### Actionbot08

##### New Member
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

#### steve the fish

##### Well-known Member
Something like:

=COUNTIF(A1:A20,">=14")/COUNT(A1:A20)

#### Actionbot08

##### New Member
Sorry about the spread of #'s... When I originally did it, they were in Excel cells.

#### Actionbot08

##### New Member
Thank you for the quick reply. Let me try that and I will get back to you.

#### Actionbot08

##### New Member
If my math is right, 11 if 55% of 20.

Am I doing something wrong?

#### Actionbot08

##### New Member
I got it... I had to change the A1:A20, to A2:A21.. THANK YOU!

#### tyija1995

##### Well-known Member
Yes 55% of 20 is 11

#### Actionbot08

##### New Member
How can I add the % after the 55?

#### Actionbot08

##### New Member
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!