Thread: [Solved] How to total 12 columns and divide them to get a percentage
View Single Post
 
Old 01-15-2013, 07:39 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi Triscia
Place your cursor in the total column and click on the Table Tools and Layout tab.
Click on the Formula button and insert the following formula in the formula box:
=SUM(LEFT)/12*100
Then change the number format to %.
Click OK.
You may need to hit F9 to calculate each time.
Good luck.
Tony
Reply With Quote