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,

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