It think that happens because Sorting does not influence links in Formulas. Such as ID 578503 was in B6 cell and the formulas in Received and Finished were referring B6 cell doing SUMIF. After the Sorting the ID 578503 rised to B2 cell, but the formulas in the Finished and Received ...
You may have problems when you try to save a Microsoft Excel workbook if one or more of the following conditions are true:You save an Excel workbook to a network drive on which you have restricted permissions. You save an Excel workbook to a location that does not have sufficient storage ...
So if you downloaded sum data from a website, it's common to get some numbers as text format special dates. Just wrap these text into a VALUE function. It will return a pure number. VALUE function Syntax =VALUE(text) So to convert a text in cell B2 into number write this VALUE form...
You may have problems when you try to save a Microsoft Excel workbook if one or more of the following conditions are true:You save an Excel workbook to a network drive on which you have restricted permissions. You save an Excel workbook to a location that does not have sufficient storage ...