Hello,

I have an array formula which works, but I would like to add a criterion to it. This is the formula:

{=AVERAGE(IF(ISNUMBER(L14:L1076),L14:L1076))}

I want to calculate the average for L14:L1076 IF the value in column E equals 1. The 1 stands for first year student, by the way; I'm working out the average score for a group of first year students.

Thanks!