filtering

[halb1961]

I have two colums. A description column and an amount column. How do I
subtotal the descriptions?

 

[Dave Peterson]

Add headers to each column if you don't have them.

Then select columns A and B (and any other used column)
Data|Sort
(and sort by column A)

Then Data|Subtotal
Subtotal by each change in the description column

 

[Max]

I have two colums. A description column and an amount column. How do I
subtotal the descriptions?

One quick n easy way is to use/create a pivot table
Select any cell in the table, click Data > Pivot table ..
Click Next > Next.
In step3, click Layout, then
drag n drop the col label for description in ROW area
drag n drop the col label for amount in DATA area
click OK > Finish,
and you'd get the desired pivot results in a new sheet to the left

---

 

[Dave Peterson]

And after you apply data|subtotals, you'll see outlining symbols to the left of
the worksheet.

You can use those to hide/show details.