I am using Microsoft XP Professional 2002
and i am using Microsoft Office 2003

I have a spreadsheet with values in column A and formulas in
column B. The cells referred in the sum formula are not consecutive(e.g.
=Sum( A32+A56+A63)). When i sort column A the total in column B changes
because the formula did not follow the values it staid in the cell. Is their
a way to have the formula follow the value when i sort so that the totals
would stay the same?

Thanks
Rodrigo F