I must be doing something wrong here.

When I put the formula at the bottom of the column I get a div/0! error.

This only clears when there are values in all the cells within the range. However, with my data set there will be situations when there will be bits of data missing. That being the case, the formula won't give a result. ....?