Percent of a number from a total number

[Actionbot08]

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:

[TABLE="width: 56"]
<colgroup><col width="56" style="width:42pt"> </colgroup><tbody>[TR]
[TD="width: 56, align: right"]31[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]

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]

Something like:

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

 

[Actionbot08]

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

 

[Actionbot08]

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

 

[Actionbot08]

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

Am I doing something wrong?

 

[Actionbot08]

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

 

[tyija1995]

You need to reference A2:A21 instead of A1:A20 as A1 is your header row
Yes 55% of 20 is 11

 

[Actionbot08]

How can I add the % after the 55?

 

[Actionbot08]

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!