Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Carrying Detail Data to Subtotal Row
I want to create subtotals, but on the subtotal row, I want to carry some of
the lines from the detail data. The "normal" subtotal function just gives me a row showing a total for the fields I am summing, plus a little "xyz key TOTAL" cell. Here is an example Part number Description Quantity On Hand Price Extended $ -------------- ------------- -------------------- ------ ------------- 123A WidgetA 1 5.00 5.00 123A WidgetA 2 5.00 10.00 123A WidgetA 10 5.00 50.00 If I subtotal on Partnumber, summing my Quantity on hand, and Extended $, I will get a row inserted something like: 123A Total 13 65.00 What I "really" want is something like this on the subtotal line (which includes non-summing items): 123A WidgetA 13 5.00 65 This tells me the part number, the description, how many on hand, their base price, and the extended price. the Part Number, Description, and Price are all STATIC in every data set I am subtotalling. I need this data presented this way, to be carried forward to another analysis, and I need to be able to cut / paste that information into another file (or back reference it). THis may be REALLY easy...but I am not an expert at this tool. Thanks, Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Subtotal when using XML data | Excel Discussion (Misc queries) |