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