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

[Interrogation]

Hi all,

[TABLE="width: 500"]
<tbody>[TR]
[TD]10[/TD]
[TD]Correct[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Correct[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]#Div/0![/TD]
[TD]Correct[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#Value![/TD]
[TD]Correct[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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")