Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averages in excel
i use excel to record students' attendance. i use each sheet for each week
and there are 12 weeks in a course. for every week i calculate the percentage attendance by using a simple average formula. the 13th sheet is the accumulative percentage attendance sheet. in this sheet i would like to know the average of attendance percentage for each student. the catch here is, if we are in week 4, the average should be for 4 weeks, that is, the total of percentage attendance is divided by 4, how ever, if we are in week 5, the average should be for 5 weeks. this means, as each week passes, the number that is dividing the total percentage should increase automatically by one. could some one help me with the formula. thank you ash |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
Moving averages in Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |