| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtotaling every third row? | Excel Worksheet Functions | |||
| Subtotaling of hours | Excel Worksheet Functions | |||
| Subtotaling problem | Excel Discussion (Misc queries) | |||
| Sorting after subtotaling | Excel Discussion (Misc queries) | |||
| Slow Subtotaling | Excel Discussion (Misc queries) | |||
Linear Mode
