If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




calculate a continuous percent of attendance if then using count.
I am setting up an attendance form that will calculate a continous percentage
of attendance. Perfect attendance per day is 8 hours. If the instructor is entering the 3rd day of attendance, the sum of the student's hours should be divided by perfect attendance for 3 days, or 24, on the 4th day, it should be divided by 32 etc. =sum(b3:y3)/sum(b1:y1) where row 1 is the perfect attendance does not work as I need a way for the computer to determine how many days the instructor has filled in, without them having to fill in counter information. 
Ads 
#2




calculate a continuous percent of attendance if then using count.
Try:
=SUMIF(B3:Y3,">0")/(COUNTIF(B3:Y3,">0")*8) HTH "IrisRandom*" wrote: > I am setting up an attendance form that will calculate a continous percentage > of attendance. Perfect attendance per day is 8 hours. If the instructor is > entering the 3rd day of attendance, the sum of the student's hours should be > divided by perfect attendance for 3 days, or 24, on the 4th day, it should be > divided by 32 etc. > > =sum(b3:y3)/sum(b1:y1) where row 1 is the perfect attendance does not > work as I need a way for the computer to determine how many days the > instructor has filled in, without them having to fill in counter information. 
#3




calculate a continuous percent of attendance if then using co
Thank you sooooo much!!! It is working beautifully.
I have never tried posting a question before  wow!! Again thank you, I will definately try this again as needed. "Toppers" wrote: > Try: > > =SUMIF(B3:Y3,">0")/(COUNTIF(B3:Y3,">0")*8) > > HTH > > "IrisRandom*" wrote: > > > I am setting up an attendance form that will calculate a continous percentage > > of attendance. Perfect attendance per day is 8 hours. If the instructor is > > entering the 3rd day of attendance, the sum of the student's hours should be > > divided by perfect attendance for 3 days, or 24, on the 4th day, it should be > > divided by 32 etc. > > > > =sum(b3:y3)/sum(b1:y1) where row 1 is the perfect attendance does not > > work as I need a way for the computer to determine how many days the > > instructor has filled in, without them having to fill in counter information. 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Count from ATTENDANCE to ANNUAL  Pietro  Excel Discussion (Misc queries)  6  March 13th 07 06:13 AM 
Best way to calculate employee attendance  Hanr3  Excel Discussion (Misc queries)  3  May 8th 06 03:50 PM 
How to calculate and then show up as a percent?  Amuse  Excel Worksheet Functions  1  July 10th 05 10:19 PM 
calculate percent increase  vlro  Excel Discussion (Misc queries)  1  December 1st 04 03:35 PM 
calculate percent from multiple criteria  Jan  Excel Worksheet Functions  0  November 10th 04 07:09 PM 