Posted by Trevor on November 01, 2001 7:10 AM
Only three columns
a = Name of state
b = Sales
c = % of total sales
the problem seems to be that the division in column c is dependant on the sum at the bottom of column b. When I try to sort to put the state with the highest sales at the top of the list - the percentages get completely whacked. The first state alphabetically is AK (cell a2), sales (cell b2), percentage (cell c2) the formula in cell c2 is =sum(b2/b52). B52 is the sum of all the sales for each state -the formula in cell b52 is =sum(b2:b51). When I run the sort, state AK falls into the 11th position (cell a12) the formula in the percentage column (c) becomes =sum(b12/c62)
If I new how to send you this little spreadsheet - I would.