Subtotals

[Guest]

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]

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.