Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percent Formula's
I have 1 column. It contains a W or an L in each individual cell down the
column to confirm wins and losses. How do I create a formula in a cell at the bottom of that column to calculate the percentage of W to the entire column of W and L? Thank you, Stephen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percent Formula's
Hello:
One way: Use the following to compute the perentage of wins, (1-wins would be percent of losses assuming no ties.) =COUNTIF(A2:A7,"w")/COUNTA(A2:A7) Assumes the w/l are in a2:a7 adjust accordingly. Pieter Vandenberg Bizman2125 wrote: : I have 1 column. It contains a W or an L in each individual cell down the : column to confirm wins and losses. How do I create a formula in a cell at : the bottom of that column to calculate the percentage of W to the entire : column of W and L? : Thank you, : Stephen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percent Formula's
If you're certain that the cells will either be blank or contain one of "W"
or "L", then try something like this: =COUNTIF(A1:A20,"W")/COUNTA(A1:A20) That formula divides the number of cells containing "W" by the number of non-blank cells. Otherwise, maybe this? : =COUNTIF(A1:A20,"W")/SUM(COUNTIF(A1:A20,{"W","L"})) That formula divides the number of cells containing "W" by the number of cells containing either "W" or "L". In either case, format the cell as percent. Does that help? *********** Regards, Ron XL2002, WinXP "Bizman2125" wrote: I have 1 column. It contains a W or an L in each individual cell down the column to confirm wins and losses. How do I create a formula in a cell at the bottom of that column to calculate the percentage of W to the entire column of W and L? Thank you, Stephen |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percent Formula's
=COUNTIF(A1:A100,"W")/COUNTA(A1:A100)
=COUNTIF(A1:A100,"L")/COUNTA(A1:100) Format cell as percentage ma ma no teeth "Bizman2125" wrote: I have 1 column. It contains a W or an L in each individual cell down the column to confirm wins and losses. How do I create a formula in a cell at the bottom of that column to calculate the percentage of W to the entire column of W and L? Thank you, Stephen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |