| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal To Include Item Description On Subtotal Line
I am using the subtotal feature on data listed below. I have requested a
subtotal of item qty at every change in the item number. The subtotal line will return the item number and the subtotaled qty. This is good. However, I wold also like the item description to be included on the subtotal line. How do I accomplish this? Item Number Item Description Item Qty RM Red Mug 100 RM Red Mug 25 RM-2 Red Dot Mug 49 RM-2 Red Dot Mug 2 -- Tickfarmer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal To Include Item Description On Subtotal Line
Data|Subtotal won't do this on its own.
I'd insert a helper column in column A and add a formula: =left(b2&rept(" ",30),30)&"-"&c2 and drag down Then use that as the control field in the subtotals. Tickfarmer wrote: I am using the subtotal feature on data listed below. I have requested a subtotal of item qty at every change in the item number. The subtotal line will return the item number and the subtotaled qty. This is good. However, I wold also like the item description to be included on the subtotal line. How do I accomplish this? Item Number Item Description Item Qty RM Red Mug 100 RM Red Mug 25 RM-2 Red Dot Mug 49 RM-2 Red Dot Mug 2 -- Tickfarmer -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal To Include Item Description On Subtotal Line
Hi Dave. Thanks so much for the suggestion. With some slight editing of
your formula, I have accomplished my goal. Appreciate your help. -- Tickfarmer "Dave Peterson" wrote: Data|Subtotal won't do this on its own. I'd insert a helper column in column A and add a formula: =left(b2&rept(" ",30),30)&"-"&c2 and drag down Then use that as the control field in the subtotals. Tickfarmer wrote: I am using the subtotal feature on data listed below. I have requested a subtotal of item qty at every change in the item number. The subtotal line will return the item number and the subtotaled qty. This is good. However, I wold also like the item description to be included on the subtotal line. How do I accomplish this? Item Number Item Description Item Qty RM Red Mug 100 RM Red Mug 25 RM-2 Red Dot Mug 49 RM-2 Red Dot Mug 2 -- Tickfarmer -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| description of count in subtotal | Excel Discussion (Misc queries) | |||
| Include Subtotal in SumIf | Excel Worksheet Functions | |||
| How do I include filtered out numbers in a SUBTOTAL? | Excel Worksheet Functions | |||
| How do you subtotal but not include the word total in the cells? | Excel Discussion (Misc queries) | |||
| HOW DO I MOVE A DESCRIPTION OR NAME INTO A SUBTOTAL LINE | Excel Worksheet Functions | |||
Hybrid Mode
