Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summary
Is there an option to summarize a certain column of information e.g
Here is an downgraded example of a table I have: IDNo CompName Description TotNoTX TotTxAmount 1234 ABC Warehouse Hammer 200 1542.40 1234 ABC Warehouse Spanner 50 445.00 1234 ABC Warehouse Nails 1000 946.50 ABC Warehouse Total 1250 2933.90(SubTotal) 2468 XYZ Wallmart Spanner 95 845.00 2468 XYZ Wallmart Screwdriver 65 640.80 2468 XYZ Wallmart Wrench 25 325.60 XYZ Wallmart Total 185 1811.40(SubTotal) Grand Total 1435 4745.30 What I want here, below the Grand Total, is a summary of the Description column e.g 1 Hammer 200 1542.40 2 Spanner 145 1290.00 1 Nails 1000 946.50 1 Wrench 25 325.60 1370 4104.50 Is this possible and how? JK |
#2
|
|||
|
|||
A pivot table would be the way to go. To learn more about
these, see: http://www.peltiertech.com/Excel/Pivots/pivottables.htm HTH Jason Atlanta, GA -----Original Message----- Is there an option to summarize a certain column of information e.g Here is an downgraded example of a table I have: IDNo CompName Description TotNoTX TotTxAmount 1234 ABC Warehouse Hammer 200 1542.40 1234 ABC Warehouse Spanner 50 445.00 1234 ABC Warehouse Nails 1000 946.50 ABC Warehouse Total 1250 2933.90(SubTotal) 2468 XYZ Wallmart Spanner 95 845.00 2468 XYZ Wallmart Screwdriver 65 640.80 2468 XYZ Wallmart Wrench 25 325.60 XYZ Wallmart Total 185 1811.40(SubTotal) Grand Total 1435 4745.30 What I want here, below the Grand Total, is a summary of the Description column e.g 1 Hammer 200 1542.40 2 Spanner 145 1290.00 1 Nails 1000 946.50 1 Wrench 25 325.60 1370 4104.50 Is this possible and how? JK . |
#3
|
|||
|
|||
Is this the only way, I need to know if there is no other means of
doing this. On Tue, 1 Feb 2005 05:20:11 -0800, "Jason Morin" wrote: A pivot table would be the way to go. To learn more about these, see: http://www.peltiertech.com/Excel/Pivots/pivottables.htm HTH Jason Atlanta, GA -----Original Message----- Is there an option to summarize a certain column of information e.g Here is an downgraded example of a table I have: IDNo CompName Description TotNoTX TotTxAmount 1234 ABC Warehouse Hammer 200 1542.40 1234 ABC Warehouse Spanner 50 445.00 1234 ABC Warehouse Nails 1000 946.50 ABC Warehouse Total 1250 2933.90(SubTotal) 2468 XYZ Wallmart Spanner 95 845.00 2468 XYZ Wallmart Screwdriver 65 640.80 2468 XYZ Wallmart Wrench 25 325.60 XYZ Wallmart Total 185 1811.40(SubTotal) Grand Total 1435 4745.30 What I want here, below the Grand Total, is a summary of the Description column e.g 1 Hammer 200 1542.40 2 Spanner 145 1290.00 1 Nails 1000 946.50 1 Wrench 25 325.60 1370 4104.50 Is this possible and how? JK . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell reference problems with Summary sheet | Excel Worksheet Functions | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Summary sheet | New Users to Excel | |||
sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) |