Formulas are not recalculating after sorting - Examples included?
Posted by Victoria on December 20, 2001 1:53 AM
I have created a spreadsheet for calculating Stock reconciliation and at present is sorted by product code. But if I try to change the sort criteria to sort by variance for example my formulas do not re-calculate according.
For example: =SUMIF(Deductions!$A$1:$A$1000,A4,Deductions!$B$1:$B$1000)
This would after sorting by the column Variance:
For Example: =SUMIF(Deductions!$A$1:$A$1000,A8,Deductions!$B$1:$B$1000)
Can you help!
Thank you in advance and Merry Christmas!