I need a formula to average the first 10 non zero values in a column while being able to insert lines to enter new data. I have found some arrays that do what I want but every time I add data I have to press Ctrl+Shift+Enter. This works well but is not user friendly when adding new data. Any suggestions would be greatly appreciated.

=AVERAGE(IF(ISNUMBER(A1:A36),IF(ROW(A1:A36)<=SMALL(IF(ISNUMBER(A1:A36),ROW(A1:A36)),10),A1:A36)))