If you want ALL the vendors listed along with $, I'd suggest a Pivot Table;
highlight your data then go to the menu bar and Data Pivot Table and Chart
Report... Let the wizard guide you, and drop the vendor in the row field and
the $ in the data field.
If you want a particular vendor's total, use sumif:
=sumif(a:a,"VendorName",b:b).


"mike" wrote:

I have a large spreadsheet that has vendor #s in column A and amounts in
column B. How do i get excel to look at all the matching vendor #s in column
A and add up all the corresponding values in column C and return the vendor #
and totals? There are multiple orders from the same vendors and I just want a
total for each returned along with the vendor #.