AverageifS on a range containing Div/Value/Error...

[Interrogation]

Hi all,

10	Correct	Yes
5	Correct	Yes
#Div/0!	Correct
15
#Value!	Correct

<tbody>
</tbody>

I simplified my problem in the above table. I want to use the averageifS formula on the first column using criteria: Correct and Yes.
I know I can use a simple criteria: ">0".
Is there a way to use averageifS and take out all the error cell out of the range like [A1:A5]\Error or "<>Error".
One of my request for the solution would be to keep averageifS and to keep the formula as simple as possible.
Do you see something that could work?

Many thanks

 

[Jon von der Heyden]

You cannot use arrays (which one could use to test for error type) in AVERAGEIFS so I believe you need to proceed with the ">0" condition:

=AVERAGEIFS(A1:A5,A1:A5,">0",B1:B5,"Correct",C1:C5,"Yes")