=SUMIF(B2:B100,7,D2:D100)/COUNTIF(B2:B100,7)

--
Ian
--
"dazp1970" wrote in message
...
Hi,

I am a teacher analysing attendance figures - and struggling somewhat!

Here's what I want to do . . .
I have a spreadsheet with the following columns:
A B C
D
Name (student) Year (7-11) attended (Y or N) %
attendance

I want to enter a formula somewhere else on the sheet that will;
select only students in Year 7 (by looking this up in column B), calculate
the average % attendance for these students only.

I will then edit this formula (in a different cell) to perform the same
calculation for year 8 students, then year 9 students . . . and so on.

I want to keep running totals so this won't be just a once-only
calculation.
As more students get added to the list I want the attendance results to
update.

Please help me!