I have a spreadsheet with dates in column A and strips of data for that date in the row off to the right. There are varying empty cells between the dates and the data so I need a function that finds the first cell in the strip of data, goes 6 cells past that cell, and averages the 6 cells of data and outputs that average into a separate cell. Can anyone help me solve this?