Hi Mike,

=SUMIF(A1:A6,1234,B1:B6)

Where 1234 is the vendor number. I believe is the v number has letters you
will have to use "" around it "ABC1234" .

HTH
Regards,
Howard

"mike" wrote in message
...
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 #.