We have a long rows of data among many names. We want to retain the historical input, but for analysis want to limit the data use in the formula to only the last ten inputs. Some rows have only one input and others as many as 100. For analysis only the last (most current) 1 to 10 data points needed. What formula can be used?

Are there blanks between most current 10 data points?

Yes, there are blanks between many of the data points in the row. What I am trying to accomplish is to sum the most current data points, but not more that the last 10. One would be the minimum and ten would be the maximum. That sum would then need to be divided by the number of data points to obtain an average. Currently, all data points are being summed. Then the number of data points for each is captured. Lastly a simple divide results in a percentage. Though the dates are fixed for data entry, there may or may not be data in a consecutive order. In fact, some rows have multiple gaps in data yet there is enough data point to exceed 10.

With your data in column A try this array formula:

=SUM(INDEX(A:A,LARGE(IF(ISBLANK(A1:A100),0,ROW(1:1 00)),10)):A100)

When entering the formula remember to hold down Ctrl and Shift before pressing Enter.