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