Hi!

See if this is what you're after:

Column A = names
Column B = price

=SUMIF(A:A,"some_name",B:B)

Biff

"minxy11" wrote in
message ...

hi, i am wanting to use vlookup and sum funtion together but dont know
how, i am using a table for transactions (employee names and prices).
what i want to do is search the transactions and add up the total sales
per person.
thanks


--
minxy11
------------------------------------------------------------------------
minxy11's Profile:
http://www.excelforum.com/member.php...o&userid=32848
View this thread: http://www.excelforum.com/showthread...hreadid=526631