#1
|
|||
|
|||
How to total 12 columns and divide them to get a percentage
I have a table of attendees for a meeting. We track this every month. We have a total of 12 columns, one for each month. When someone attends I enter a 1 beside their name. If they don't attend they receive a 0. On the far right in the last column I want to be able to total the columns and divide them by 12 to find out the percentage of their attendance for the year. TIA |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
formula divide by serio error | vthomeschoolmom | Excel | 1 | 04-18-2012 02:29 PM |
divide page into 4 parts | aclark17 | Word | 4 | 01-17-2012 09:04 AM |
percentage on columns | 911 | Excel | 1 | 09-01-2010 09:28 AM |
Divide by zero error | doublejoy | Excel | 1 | 08-22-2009 03:10 AM |