Sort multiple columns with multiple formulas without returning #R
 

I have a costing spreadsheet with multiple formulas in the various cells.
When i try to sort the data with expanded selection, my formulas return as
#REF