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
.