When Sorting in Excel

[Rodrigo]

Please Help

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

 

[Guest]

Please Help

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

 

[fredg]

Please Help

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

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.