SUMIF - my formula misreads after data has been sorted

[Guest]

I am using a =sumif formula that is reading information from a source sheet.
So, if I insert a line on row 64 it calculates that if the information in the
range onthe source sheet matches that in cell a on the worksheet, then it
should take the figure from the source sheet that it matches. This works but
then if I sort my data on the work sheet so that the information inserted
into row 64 moves to say row 33 (where it goes alphabetically) the formula
continues to read the information on row 64 ... why does this happen and how
can I stop it happening?

 

[Bernard Liengme]

Change to absolute references; e,g not A5 but $A$5
best wishes

 

[Guest]

What does your formula look like before and after the sort?