try using an IF function. set up column c with the following equation,
=IF(A1=vendor #,B1,0).with this formula insert the actual vendor number where
I typed vendor #. this should give you the values for every entry on that
particular vendor one at a time in column c. I would designate that column
for just one vendor. then in the next available space column d, e, f, what
ever you want to use, you can use a SUM function for all of the values in
column c

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 #.