subtotaling
 

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.

subtotaling
 

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

"Mike Morris" wrote:

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.

subtotaling
 

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.
--
HTH...

Jim Thomlinson


"Mike Morris" wrote:

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.