Interrogation
New Member
- Joined
- Nov 22, 2018
- Messages
- 3
Hi all,
<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
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