Percent of total

  • Thread starter Thread starter lynn
  • Start date Start date
L

lynn

I need a formula that will tell me what percent of the
total for each group. Example, in column b I have a number
representing a number of submissions per department.
(group A submitted 22, group B submitted 14, group C
submitted 9). Everything together would be 100%. I need a
formula to give me what % out of 100 for each group. Does
this make sense ?
 
Hi Lynn

assuming data

A B C
1 A 22 =B1/SUM($B$1:$B$3)
2 B 14 =B2/SUM($B$1:$B$3)
3 C 9 =B3/SUM($B$1:$B$3)
4 =SUM(C1:C3)

then select from C1 to C4 and click on the % on the toolbar

Hope this helps
Cheers
JulieD
 
It makes perfect sense. You should run for president. <g>

Okay, so you have something like:

Dept Submissions
Group A 22
Group B 14
Group C 9

In C2 you'll enter a formula like this:

=B2/Sum($B$2:$B$4)


Copy it down as far as you have data in Column B.

tod
 
worked perfect. Thanks !

-----Original Message-----
Hi Lynn

assuming data

A B C
1 A 22 =B1/SUM($B$1:$B$3)
2 B 14 =B2/SUM($B$1:$B$3)
3 C 9 =B3/SUM($B$1:$B$3)
4 =SUM(C1:C3)

then select from C1 to C4 and click on the % on the toolbar

Hope this helps
Cheers
JulieD





.
Click to expand...
 
Back
Top