Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-04-2013, 12:22 PM
Triscia Triscia is offline How to total 12 columns and divide them to get a percentage Windows 7 32bit How to total 12 columns and divide them to get a percentage Office 2007
Novice
How to total 12 columns and divide them to get a percentage
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to total 12 columns and divide them to get a percentage 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft