Sorting Date

[CM]

Hi All,

I have a spreadsheet that contains a column that displays each rows value as
a % of the total of the column. When I sort the data using different
criteria the %'s come undone?

Any thoughts on how to fix this.

Many thanks,

CM

 

[Jason Morin]

You need to make the reference in your SUM function
absolute (or at least fixing the row reference) using $.
For example:

=A1/SUM($A$1:$A$10)

HTH
Jason
Atlanta, GA