SUMIF - my formula misreads after data has been sorted
 

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?

SUMIF - my formula misreads after data has been sorted
 

Change to absolute references; e,g not A5 but $A$5
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Poodles" wrote in message
...
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?

SUMIF - my formula misreads after data has been sorted
 

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

"Poodles" wrote:

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?