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

 

[RoryA]

I haven't had time to test, but it looks like you could use:

=AVERAGEIFS($I$7:$AC$7,"D*",I8:AC8,"<>0")

 

[JEC]

Shows how important sample data is, once again

 

[bonbonboy]

Thx for the move Rory.
Unfortunately your formula doesn't work.
@JEC i don't get what i have to fix in your function row because the range of cells you gave (column A) is empty in my sheet

 

[RoryA]

Apologies - I forgot the value range!

=AVERAGEIFS(I8:AC8,$I$7:$AC$7,"D*",I8:AC8,"<>0")

 

[bonbonboy]

it works great Rory, thank you for your help!
Thank you JEC to for your help too!

Have a good day