Subtotal results in new column and then sorting subtotals

ArtM · Jan 17, 2005

1. Is there a way to do a subtotal and have the results appear in a new column

and

2. Is there a way to then sort on those subtotals (high to low)?

Ola · Jan 18, 2005

You could, use a pivottable or =SUMIF(color_range,="red",sum_range)

Ola Sandstrom