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?