subtotaling

[Mike Morris]

PO# line no Description Quantity

555-00 2 11-4040-605NL 220
555-00 2 11-4040-605NL 100
555-00 2 11-4040-605NL 500
555-00 2 11-4040-605NL 20
555-00 3 11-4040-618 160
555-00 3 11-4040-618 100
555-00 3 11-4040-618 20
555-00 3 11-4040-618 20
555-00 3 11-4040-618 240
555-00 3 11-4040-618 20
555-00 3 11-4040-618 20
555-00 3 11-4040-618 40
555-00 3 11-4040-618 20
555-00 4 60-2517-618 400
555-00 4 60-2517-618 160
555-00 4 60-2517-618 80


I need to get subtotals for the amounts in the "quantity" column, where "po
#" and line #" are the same.

 

[dlw]

There is a subtotals option on the data menu, help screens explain it well

 

[Jim Thomlinson]

My preference for this sort of thing is pivot tables. Put your cursor in the
middle of your source data ans select Data -> Pivot Table. You can probably
just select finish when the wizard opens up as XL tends to make the correct
assumptions. Drag the PO #, Line # and description into the left hand column
ad put the Quantity in the middle. There are also a number of great auto
formatting options.