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

I dont think that is possible. The only thing I could think of to do is:

Enter the formulas in column B and verify you have the results you want.

Copy the entire column B, right click on the top of column B and select
"Paste Special". When the next little box opens, click on "Values" in the
"Paste Section" and hit OK.

This will paste over the formulas with the results as actual numbers, but
the formulas will be deleted.

If you want to keep the formulas, but still show the results even after you
sort, then paste special in Column C.

"Rodrigo" wrote:


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

That doesnt work, i need to keep the cells with formulas because of auditing
purposes.

Can anyone else help?

"JasonP CCTM LV" wrote:

I dont think that is possible. The only thing I could think of to do is:

Enter the formulas in column B and verify you have the results you want.

Copy the entire column B, right click on the top of column B and select
"Paste Special". When the next little box opens, click on "Values" in the
"Paste Section" and hit OK.

This will paste over the formulas with the results as actual numbers, but
the formulas will be deleted.

If you want to keep the formulas, but still show the results even after you
sort, then paste special in Column C.

"Rodrigo" wrote:


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

On Sep 26, 8:15*am, Rodrigo wrote:
That doesnt work, i need to keep the cells with formulas because of auditing
purposes.

Can anyone else help?

"JasonP CCTM LV" wrote:
I dont think that is possible. *The only thing I could think of to do is:

Enter the formulas in column B and verify you have the results you want..

Copy the entire column B, right click on the top of column B and select
"Paste Special". *When the next little box opens, click on "Values" in the
"Paste Section" and hit OK.

This will paste over the formulas with the results as actual numbers, but
the formulas will be deleted.

If you want to keep the formulas, but still show the results even after you
sort, then paste special in Column C.

"Rodrigo" wrote:

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

Select the column with the formulas.
Go Edit|Replace...
In the Find what: box just type an equals sign.
In the Replace with: box type a character that is neither a wildcard
nor a character that appears in any of the formulas. I used the Pipe
(Shift+ the key below the Backspace key).
Click Replace All.
Now do your sort.
Now use Edit|Replace with the Find what: and Replace with: values
swapped over to return to the formulas.

Ken Johnson

I think what you are showing me keeps the fomulas in the cell when you sort.
What i need is for the formula to follow the value or the amount when i sort.
So that when i do sort, the total amount with the formula would not change.

Thanks i appreciated

"Ken Johnson" wrote:

On Sep 26, 8:15 am, Rodrigo wrote:
That doesnt work, i need to keep the cells with formulas because of auditing
purposes.

Can anyone else help?

"JasonP CCTM LV" wrote:
I dont think that is possible. The only thing I could think of to do is:

Enter the formulas in column B and verify you have the results you want..

Copy the entire column B, right click on the top of column B and select
"Paste Special". When the next little box opens, click on "Values" in the
"Paste Section" and hit OK.

This will paste over the formulas with the results as actual numbers, but
the formulas will be deleted.

If you want to keep the formulas, but still show the results even after you
sort, then paste special in Column C.

"Rodrigo" wrote:

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

Select the column with the formulas.
Go Edit|Replace...
In the Find what: box just type an equals sign.
In the Replace with: box type a character that is neither a wildcard
nor a character that appears in any of the formulas. I used the Pipe
(Shift+ the key below the Backspace key).
Click Replace All.
Now do your sort.
Now use Edit|Replace with the Find what: and Replace with: values
swapped over to return to the formulas.

Ken Johnson

On Sep 26, 10:23*am, Rodrigo
wrote:
I think what you are showing me keeps the fomulas in the cell when you sort.