Array Average Formula with one additional criterion

[hokkaido19]

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!

[Pepe Le Mokko]

Perhaps =AVERAGEIF(I14:I1076,"=1",L14:L1076) ( no array needed)

[hokkaido19]

Great, Thank You!

[Pepe Le Mokko]

You're welcome