how to use AVERAGEIF with 12 arguments?

[bonbonboy]

Hello here

I would like to calculate the average of chosen cells in excluding 0.

Based on that formula

=AVERAGEIF(I8,K8,M8,O8,Q8,S8,U8,W8,Y8,AA8,AC8,"<>0")

, i have to much arguments BUT i cannot take a range.
In J8, L8, N8 etc... there are some values i don't want to include in the calculation of the average.

Also i cannot make it vertically because each horizontal line defines someone, that's why my goal is to get my formula for each line.

Do you have some ideas please?
Thank you beforehand

 

[JEC]

Take a look at AVERAGEIFS

 

[bonbonboy]

Thx for your reply but it doesn't work, AVERAGEIFS expects all arguments after position 3 to be in pairs :/
And i cannot create some small ranges as (I8:K8, M8:O8...), each cell is independent.

 

[RoryA]

Do you have any sort of indicator like a header row that could be used to determine which columns to include?

Also, I suggest you update your profile to indicate which version of Office you have as it will affect the possible solutions.

 

[JEC]

Try this

=AVERAGE(IFERROR(1/(1/(INDEX(I8:AC8,2*(ROW(A1:A11)-1)+1))),""))

 

[JEC]

Two more

=AVERAGE(IFERROR(1/(1/(IF(ISODD(ROW(1:21)),TRANSPOSE(I8:AC8),""))),""))

=AVERAGE(IFERROR(1/(1/(FILTER(I8:AC8,TRANSPOSE(ISODD(SEQUENCE(21)))))),""))

 

[bonbonboy]

@RoryA my sheet is on google sheets.
Below a sample of my table

		H	I	J	K	L	M	N	O
		23/12	24/12	27/12	28/12
		Total	Daily	T	D	T	D	T	D
8	Mike	38	38	38	0	38	0	38	0
9	Lewis	31	31	147	116	282	135	313	31
10	Arnold	0	0	0	0	0	0	19	19
11	Carol	0	0	0	0	334	334	385	51

@JEC : your formula works for the line 8, but not at all for the next lines

 

[JEC]

Yes you need to Fix the row function

=AVERAGE(IFERROR(1/(1/(INDEX(I8:AC8,2*(ROW($A$1:$A$11)-1)+1))),""))

 

[bonbonboy]

I can't edit, so @JEC your formulaS work for the line 8, but for the next line

 

[RoryA]

my sheet is on google sheets.

Then this is not the correct forum, so I'll move it.