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:
<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
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