This seems like it is so stupid and easy to do but I cannot think of anything right now. I tried copy/pasting. And even copy, and paste spcial(with every special paste) and cannot get this.

I'm using Excel 2007. I have a list of Vendors with the amounts of checks we have sent out. I'm trying to find a "total spend for each vendor" from this past year. I was hoping a simple Subtotal, and then copy/paste values or something like that would work.

Example:

Vendor Name Amount
Owl Jolson 144
Owl Jolson 34577
Owl Jolson 324234
George Jetson 15
Ginger Rogers 3
Ginger Rogers 565
Ginger Rogers 5345
**** Tracy 744


Subtotaling by the amount(To get a listing of the vendor once, along with the total payment amount), and then copy/pasting doesn't get me them. I'm trying to get the vendor name, and then the total spend of each vendor.

Apparently my shortcuts suck