| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I calculate a percentage of a column?
I'm using Excel 2002 and have 3 columns. Column B is a series of Y's and N's
(Yes/No). At the bottom of the column, I would like to calculate the percentage of Y's. This sheet is a completeness report, so knowing how much work is complete in percentage would be helpful. Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I calculate a percentage of a column?
Hi
Try this one: =COUNTIF(A3:A11,"y")/(COUNTIF(A3:A11,"y")+COUNTIF(A3:A11,"n")) Format the cell to %age Regards Rajesh "Geoff" wrote: I'm using Excel 2002 and have 3 columns. Column B is a series of Y's and N's (Yes/No). At the bottom of the column, I would like to calculate the percentage of Y's. This sheet is a completeness report, so knowing how much work is complete in percentage would be helpful. Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I calculate a percentage of a column?
Thanks! Worked perfectly
"rajesh" wrote: Hi Try this one: =COUNTIF(A3:A11,"y")/(COUNTIF(A3:A11,"y")+COUNTIF(A3:A11,"n")) Format the cell to %age Regards Rajesh "Geoff" wrote: I'm using Excel 2002 and have 3 columns. Column B is a series of Y's and N's (Yes/No). At the bottom of the column, I would like to calculate the percentage of Y's. This sheet is a completeness report, so knowing how much work is complete in percentage would be helpful. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate a productivity percentage | New Users to Excel | |||
| How do you calculate a negative percentage | Excel Worksheet Functions | |||
| PIVOT TABLE Custom Column addition to calculate sum and Percentage | Excel Discussion (Misc queries) | |||
| calculate percentage | Excel Worksheet Functions | |||
| calculate percentage of two cells | Excel Worksheet Functions | |||
Linear Mode
