#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 |
|
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 |