weekdaty Average IFs formula

[Sparda142]

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

	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>

 

[Sparda142]

Meaning can you set up your secondary table like this(Vertically instead of horizontal-transposed)? because then you can just use 1 formula and always drag it down and over, rather than having 3 formulas

Excel 2010

	A	B	C	D	E	F	G	H	I	J	K
1		Name	John	Jacob	Jill			John	Jacob	Jill
2	2	1-Jul	90%	87%	100%		1	93%	98%	CHECK
3	3	2-Jul		60%	60%		2	90%	87%	12%
4	4	3-Jul	30%	77%	100%		3	0%	64%	67%
5	5	4-Jul			73%		4	30%	39%	0%
6	6	5-Jul	87%				5	CHECK	CHECK	73%
7	7	6-Jul	76%	76%			6	87%	CHECK	CHECK
8	1	7-Jul	93%	98%	100%		7	76%	76%	CHECK
9	2	8-Jul	100%	100%	12%
10	3	9-Jul	0%	67%	73%
11	4	1-Jul		0%	0%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Worksheet Formulas Cell Formula H2 =IFERROR(AVERAGEIFS(C$2:C$11,$A$2:$A$11,$G2,C$2:C$11,"<>100%"),"CHECK") I2 =IFERROR(AVERAGEIFS(D$2:D$11,$A$2:$A$11,$G2,D$2:D$11,"<>100%"),"CHECK") J2 =IFERROR(AVERAGEIFS(E$2:E$11,$A$2:$A$11,$G2,E$2:E$11,"<>100%"),"CHECK") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

I placed the data vertically and use your formulas, It worked! thanks for all the help!

 

[Twollaston]

No problem