filtering
 

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

filtering
 

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



halb1961 wrote:

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

--

Dave Peterson

filtering
 

"halb1961" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

filtering
 

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.

Dave Peterson wrote:

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

halb1961 wrote:

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

--

Dave Peterson

--

Dave Peterson