Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotals
I have a spreadsheet and have used the subtotal (Data -- Subtotals). I have
chosen to subtotal dollar amount for a particular vendor number, however the names of the vendors does not appear then. How can I get the name of the vendor to appear as well? Thanks, |
#2
|
|||
|
|||
Instead of subtotals, you could use a pivot table to summarize the data.
Jon Peltier has instructions and links on his web site: http://www.peltiertech.com/Excel/Pivots/pivotstart.htm Add Vendor number and Vendor name to the row area, and put the dollar field into the data area, where it will become Sum of Dollars. TJAC wrote: I have a spreadsheet and have used the subtotal (Data -- Subtotals). I have chosen to subtotal dollar amount for a particular vendor number, however the names of the vendors does not appear then. How can I get the name of the vendor to appear as well? Thanks, -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
Levels in Subtotals | Excel Worksheet Functions | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) |