average of last 5 in a table

Hi, just an extension on this, there has to be at least 4 figures in the last 4 columns for this to work, but sometimes there are products with just one rate of pay and it throws up an error

ive attached a document to help explain this. thanks.