Formula that skips blank cells

**chisox721** · 12-16-2013, 03:41 PM

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.

**protonLeah** · 12-16-2013, 04:33 PM

To attach a Workbook
(please do not post pictures of worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"

**chisox721** · 12-16-2013, 04:44 PM

Doesn't include the formulas as I pasted values only to the sample, but it should give an understanding of what I'm trying to accomplish.

"DS average of last 5" needs to average the last 5 DS points, which would skip the blank in cell AF23.