Hello,
I'm having trouble with the formula below, Im getting "Too few arguments" . Where am i going wrong with the formula below?
CELL H2 FORMULA =IFERROR(AVERAGEIFS(C2:C11,"<>100%", C1:E1,G2,A2:A11,H1)"CHECK")
<tbody>
</tbody>
I'm having trouble with the formula below, Im getting "Too few arguments" . Where am i going wrong with the formula below?
CELL H2 FORMULA =IFERROR(AVERAGEIFS(C2:C11,"<>100%", C1:E1,G2,A2:A11,H1)"CHECK")
a | b | c | d | e | f | g | H | I | J | K | L | M | N | O | P | Q | R | |
1 | Name | John | Jacob | Jill | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||||||
2 | 2 | 7/1 | 90% | 87% | 100% | John | ||||||||||||
3 | 3 | 7/2 | 60% | 60% | Jacob | |||||||||||||
4 | 4 | 7/3 | 30% | 77% | 100% | Jill | ||||||||||||
5 | 5 | 7/4 | 73% | |||||||||||||||
6 | 6 | 7/5 | 87% | |||||||||||||||
7 | 7 | 7/6 | 76% | 76% | ||||||||||||||
8 | 1 | 7/7 | 93% | 98% | 100% | |||||||||||||
9 | 2 | 7/8 | 100% | 100% | 12% | |||||||||||||
10 | 3 | 7/9 | 0% | 67% | 73% | |||||||||||||
11 | 4 | 7/1 | 0% | 0% |
<tbody>
</tbody>