The error is in sheet 'Extract'. Are you suggesting that if the source data (i.e. 'SalesExportTable') has issues such as blank or other the formula in 'Extract' may produce an error?

If so how would we than explain the issue goes away if I rebuild the formulas?