Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating percentages
I am new at excel. I have inputs done by group 1 of 5410. Inputs done by
group 2 of 2420. So, I have a total of 7830 inputs. How do I calculate the percentage done by group 1 over group 2? -- Thanks - Lindamac |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating percentages
You can use:
=countif(a:a,"group1") to count the number of "Group1"'s in column A. =counta(a:a) will count the number of entries (text, numbers, formulas) in column A. So maybe something like: =countif(a:a,"group1") / counta(a:a) would give you the percentage of group1's lindamac wrote: I am new at excel. I have inputs done by group 1 of 5410. Inputs done by group 2 of 2420. So, I have a total of 7830 inputs. How do I calculate the percentage done by group 1 over group 2? -- Thanks - Lindamac -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating percentages
=5410/7830 returns 69% for group 1
What's left over has been done by group 2 Gord Dibben MS Excel MVP On Thu, 6 May 2010 13:47:01 -0700, lindamac wrote: I am new at excel. I have inputs done by group 1 of 5410. Inputs done by group 2 of 2420. So, I have a total of 7830 inputs. How do I calculate the percentage done by group 1 over group 2? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating percentages in P&L | Excel Discussion (Misc queries) | |||
calculating percentages | Excel Worksheet Functions | |||
Calculating percentages | Excel Discussion (Misc queries) | |||
calculating percentages | Excel Discussion (Misc queries) | |||
Calculating Percentages | Excel Discussion (Misc queries) |