Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ATTENDANCE SPREADSHEET
Me again! Some of our students have to attend 6 times and some 7. They are
listed down column A with various details (including attendance) running across the row. At the end of all of their attendance days is a 'total attendance'column. Assuming they all attend all of the days (I wish!!) is there a one formula fits all solution to show the percentage of attendance for each student. If they do attend 6 or 7 (as required) it will still amount to 100%. I could then copy that formula down all of the students and this would save separate formulae for each of the 6's and 7's. A nightmare to sort out! Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ATTENDANCE SPREADSHEET
How do you indicate in column A that it should be 6 or 7 attendances for
each student? Is your attendance shown as Y and absence shown as A, or do you have some other codes? Do you leave the column blank for a student who is not expected to be in (on the 7th session)? Please give a few more details. Pete "Chris" wrote in message ... Me again! Some of our students have to attend 6 times and some 7. They are listed down column A with various details (including attendance) running across the row. At the end of all of their attendance days is a 'total attendance'column. Assuming they all attend all of the days (I wish!!) is there a one formula fits all solution to show the percentage of attendance for each student. If they do attend 6 or 7 (as required) it will still amount to 100%. I could then copy that formula down all of the students and this would save separate formulae for each of the 6's and 7's. A nightmare to sort out! Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ATTENDANCE SPREADSHEET
Thanks Pete. I was hoping to use Y and A but having already had some problems with using a letter (with autocorrect that affected the whole suite!) I was hoping to just use a 1 for attending and 0 for non attendance. The 7th attendance, if not needed, would be blank. If that would create yet more problems maybe you have a suggestion? Chris "Pete_UK" wrote: How do you indicate in column A that it should be 6 or 7 attendances for each student? Is your attendance shown as Y and absence shown as A, or do you have some other codes? Do you leave the column blank for a student who is not expected to be in (on the 7th session)? Please give a few more details. Pete "Chris" wrote in message ... Me again! Some of our students have to attend 6 times and some 7. They are listed down column A with various details (including attendance) running across the row. At the end of all of their attendance days is a 'total attendance'column. Assuming they all attend all of the days (I wish!!) is there a one formula fits all solution to show the percentage of attendance for each student. If they do attend 6 or 7 (as required) it will still amount to 100%. I could then copy that formula down all of the students and this would save separate formulae for each of the 6's and 7's. A nightmare to sort out! Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
ATTENDANCE SPREADSHEET
No, that's fine. COUNT(range) will count all the cells which are not empty
and which contain numbers, so that represents the maximum attendances expected. COUNTIF can be used to count only the cells containing a particular value (1), so you can put these together to get a percentage: =COUNTIF(range,1)/COUNT(range) and format the cell as a percentage. Here "range" will be something like B2:AM2 for the first student in row 2, and then you can copy this down for the other students. Hope this helps. Pete "Chris" wrote in message ... Thanks Pete. I was hoping to use Y and A but having already had some problems with using a letter (with autocorrect that affected the whole suite!) I was hoping to just use a 1 for attending and 0 for non attendance. The 7th attendance, if not needed, would be blank. If that would create yet more problems maybe you have a suggestion? Chris "Pete_UK" wrote: How do you indicate in column A that it should be 6 or 7 attendances for each student? Is your attendance shown as Y and absence shown as A, or do you have some other codes? Do you leave the column blank for a student who is not expected to be in (on the 7th session)? Please give a few more details. Pete "Chris" wrote in message ... Me again! Some of our students have to attend 6 times and some 7. They are listed down column A with various details (including attendance) running across the row. At the end of all of their attendance days is a 'total attendance'column. Assuming they all attend all of the days (I wish!!) is there a one formula fits all solution to show the percentage of attendance for each student. If they do attend 6 or 7 (as required) it will still amount to 100%. I could then copy that formula down all of the students and this would save separate formulae for each of the 6's and 7's. A nightmare to sort out! Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
ATTENDANCE SPREADSHEET
Thanks Pete, that worked brilliantly. After 2 days of slogging on it I had
given up hope and lost the will to live! Thanks Chris "Pete_UK" wrote: No, that's fine. COUNT(range) will count all the cells which are not empty and which contain numbers, so that represents the maximum attendances expected. COUNTIF can be used to count only the cells containing a particular value (1), so you can put these together to get a percentage: =COUNTIF(range,1)/COUNT(range) and format the cell as a percentage. Here "range" will be something like B2:AM2 for the first student in row 2, and then you can copy this down for the other students. Hope this helps. Pete "Chris" wrote in message ... Thanks Pete. I was hoping to use Y and A but having already had some problems with using a letter (with autocorrect that affected the whole suite!) I was hoping to just use a 1 for attending and 0 for non attendance. The 7th attendance, if not needed, would be blank. If that would create yet more problems maybe you have a suggestion? Chris "Pete_UK" wrote: How do you indicate in column A that it should be 6 or 7 attendances for each student? Is your attendance shown as Y and absence shown as A, or do you have some other codes? Do you leave the column blank for a student who is not expected to be in (on the 7th session)? Please give a few more details. Pete "Chris" wrote in message ... Me again! Some of our students have to attend 6 times and some 7. They are listed down column A with various details (including attendance) running across the row. At the end of all of their attendance days is a 'total attendance'column. Assuming they all attend all of the days (I wish!!) is there a one formula fits all solution to show the percentage of attendance for each student. If they do attend 6 or 7 (as required) it will still amount to 100%. I could then copy that formula down all of the students and this would save separate formulae for each of the 6's and 7's. A nightmare to sort out! Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
ATTENDANCE SPREADSHEET
Well, Chris, I hope you are suitably invigorated now to face the next
challenges - thanks for feeding back. Pete "Chris" wrote in message ... Thanks Pete, that worked brilliantly. After 2 days of slogging on it I had given up hope and lost the will to live! Thanks Chris "Pete_UK" wrote: No, that's fine. COUNT(range) will count all the cells which are not empty and which contain numbers, so that represents the maximum attendances expected. COUNTIF can be used to count only the cells containing a particular value (1), so you can put these together to get a percentage: =COUNTIF(range,1)/COUNT(range) and format the cell as a percentage. Here "range" will be something like B2:AM2 for the first student in row 2, and then you can copy this down for the other students. Hope this helps. Pete "Chris" wrote in message ... Thanks Pete. I was hoping to use Y and A but having already had some problems with using a letter (with autocorrect that affected the whole suite!) I was hoping to just use a 1 for attending and 0 for non attendance. The 7th attendance, if not needed, would be blank. If that would create yet more problems maybe you have a suggestion? Chris "Pete_UK" wrote: How do you indicate in column A that it should be 6 or 7 attendances for each student? Is your attendance shown as Y and absence shown as A, or do you have some other codes? Do you leave the column blank for a student who is not expected to be in (on the 7th session)? Please give a few more details. Pete "Chris" wrote in message ... Me again! Some of our students have to attend 6 times and some 7. They are listed down column A with various details (including attendance) running across the row. At the end of all of their attendance days is a 'total attendance'column. Assuming they all attend all of the days (I wish!!) is there a one formula fits all solution to show the percentage of attendance for each student. If they do attend 6 or 7 (as required) it will still amount to 100%. I could then copy that formula down all of the students and this would save separate formulae for each of the 6's and 7's. A nightmare to sort out! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tracking Attendance | Excel Discussion (Misc queries) | |||
Attendance Sheet. | Excel Discussion (Misc queries) | |||
attendance log | New Users to Excel | |||
how do i set up a time and attendance database/spreadsheet? | Excel Discussion (Misc queries) | |||
Attendance spreadsheet | Excel Worksheet Functions |