Are you saying that if you have values (eg 100, 200, 300, 400, 500) in
specific cell (eg B3, B7, B9, B12, B20) before the sort, then after the
sort you want the came values (not cells) to be summed?
One way would be to convert the formula to a value. So you type =
B3+B7+B9+B12+B20, then you use Copy followed by Edit | Paste Special ->
Values. Now you can sort and the results is unaltered.
Failing this, can you reveal the criteria used to select the 5 dollar
values?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"David" <davrud@gmail.com> wrote in message
news:1141243439.805703.206640@v46g2000cwv.googlegroups.com...
> Hmm, I appreciate the reply, however their is a disconnect (and likely
> with me). I will restate my problem, with a more practical example,
> vs. the hypothetical described earlier. I have a list of customers
> (company names) in column A, a matching list of dollar values
> associated with each customer in column B, and a list of US States in
> column C.
>
> I have sorted by the largest dollar value to the smallest. I have a
> calculation that adds 5 different dollar values that spread across the
> dataset. Now I wish to sort my dataset by State (in alphabetical
> order). Doing so completely throws off my calculation.
>
> This is what I am trying to fix. I hope this is more clear.
>
Bookmarks