Excel-如何获取行中最后10个值的平均值,该值由数字和“ N / A”的随机混合组成

So i have a row of numbers which is consistently added to, which may be like 4,N/A,N/A,5,5,6,7,4,N/A,N/A,N/A,5,N/A and I need a formula which is able to calculate the average of the last 10 numbers in the row.

我努力了

=AVERAGE(OFFSET(C7,0,COUNT(C7:X7)-MIN(10,COUNT(C7:X7)),1,MIN(10,COUNT(C7:X7))))