Sorting Date

  • Thread starter Thread starter CM
  • Start date Start date
C

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
 
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
 
Back
Top