comparing two columns & then perform a calculation
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!
|