View Single Post
 
Old 01-04-2013, 12:22 PM
Triscia Triscia is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jan 2013
Posts: 4
Triscia is on a distinguished road
Default 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
Reply With Quote