I know that I have to use an array formula for this, but I am not getting the correct results.
This is what I have:
Results; Scores
F25 = 5; I25 = 8.5
F26 = 4; I26 = 9.0
F27 = 8; I27 = 8.0
F28 = 3; I28 = 8.0
F29 = 1; I29 = 7.0
F30 = 5; I30 = 7.0
F31 = 9; I31 = 8.5
F32 = 7; I32 = 8.5
F33 = 4; I33 = 9.5
... ; ...
... ; ...
F64; I64
I want to calculate the average of the LAST 3 RESULTS that are less than equal to 8.5 but greater than or equal to 8.0.
(I25:I64 <= 8.5) (I25:I64 >= 8.0)
So, in the above example the result is 6.33 = [f32 (7) + f31 (9) + f28 (3)]
Anyway I can accomplish this?
Thanks in advanced.
This is what I have:
Results; Scores
F25 = 5; I25 = 8.5
F26 = 4; I26 = 9.0
F27 = 8; I27 = 8.0
F28 = 3; I28 = 8.0
F29 = 1; I29 = 7.0
F30 = 5; I30 = 7.0
F31 = 9; I31 = 8.5
F32 = 7; I32 = 8.5
F33 = 4; I33 = 9.5
... ; ...
... ; ...
F64; I64
I want to calculate the average of the LAST 3 RESULTS that are less than equal to 8.5 but greater than or equal to 8.0.
(I25:I64 <= 8.5) (I25:I64 >= 8.0)
So, in the above example the result is 6.33 = [f32 (7) + f31 (9) + f28 (3)]
Anyway I can accomplish this?
Thanks in advanced.
Last edited: