Remember Me?

#1
May 3rd 07, 06:48 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: May 2007 Posts: 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.

#2
May 3rd 07, 07:04 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,339
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
May 3rd 07, 07:23 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: May 2007 Posts: 1
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Pietro Excel Discussion (Misc queries) 6 March 13th 07 06:13 AM Hanr3 Excel Discussion (Misc queries) 3 May 8th 06 03:50 PM Amuse Excel Worksheet Functions 1 July 10th 05 10:19 PM vlro Excel Discussion (Misc queries) 1 December 1st 04 03:35 PM Jan Excel Worksheet Functions 0 November 10th 04 07:09 PM

All times are GMT +1. The time now is 12:46 AM.