| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Percentage
How do i get a figure for Percentage in xl? I have a set of cells that i need
to know the percentage of. For example: Cell B6 to B 50 has names in it, what is the percentage of individuals in the cell? thanks in advance. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percentage
Assume you want to know what % of entries contain Bob:
Assumes there are no empty/blank cells within the range: =COUNTIF(B$6:B$50,"Bob")/ROWS(B$6:B$50) Format as PERCENTAGE Biff "help with excel" wrote in message ... How do i get a figure for Percentage in xl? I have a set of cells that i need to know the percentage of. For example: Cell B6 to B 50 has names in it, what is the percentage of individuals in the cell? thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| percentage | Excel Worksheet Functions | |||
| percentage | Excel Discussion (Misc queries) | |||
| percentage | Excel Worksheet Functions | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Linear Mode
