How to get the average of the 5th to 10th non-zero values in a row?

[sshvaika]

Hello everyone, I'm new to this forum and looking for help.

I have a row, like this one:

0​

2​

0​

1​

2​

7​

8​

1​

0​

3​

0​

1​

0​

3​

0​

4​

8​

0​

How can I calculate the average of non-zero 5-10 values (I marked them in bold)?

Thank you a lot,

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1
2		0	2	0	1	2	7	8	1	0	3	0	1	0	3	0	4	8	0	3.333333
3
Main

Cell Formulas
Range	Formula
T2	T2	=AVERAGE(INDEX(FILTER(B2:S2,B2:S2<>0),SEQUENCE(6,,5)))