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.