I'm currently working on a spreadsheet that analyzes basketball statistics and ran into a problem. I import the data from a website and every so often the website will add a header within the statistics, which gives me a row of blank cells where my calculations of the data are located.

My problem is that I'm trying to add a formula for "average of last 5 games" and having a blank cell every so often between some of the calculations means the formula won't actually use the last 5 results, unless there is a way to skip over the blank cell and truly return the past 5 results.

Any thoughts/ideas on this would be greatly appreciated.