software

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: www.excelforum.com/member.php...oamp;userid=32848
View this thread: www.excelforum.com/showthread...hreadid=526631Hi!

See if this is what you're after:

Column A = names
Column B = price

=SUMIF(A:A,quot;some_namequot;,B:B)

Biff

quot;minxy11quot; gt; wrote in
message ...
gt;
gt; hi, i am wanting to use vlookup and sum funtion together but dont know
gt; how, i am using a table for transactions (employee names and prices).
gt; what i want to do is search the transactions and add up the total sales
gt; per person.
gt; thanks
gt;
gt;
gt; --
gt; minxy11
gt; ------------------------------------------------------------------------
gt; minxy11's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32848
gt; View this thread: www.excelforum.com/showthread...hreadid=526631
gt;
Hi,

You can try this

Name Sales
(Column A) (Column B)
A 100
B 200
C 300
A 1000
B 2000
C 3000

SUMIF(range,criteria,[sum_range])
=SUMIF(A:A,quot;Bquot;,B:B)

I Hope this will help you.

Sridhar

quot;minxy11quot; wrote:

gt;
gt; hi, i am wanting to use vlookup and sum funtion together but dont know
gt; how, i am using a table for transactions (employee names and prices).
gt; what i want to do is search the transactions and add up the total sales
gt; per person.
gt; thanks
gt;
gt;
gt; --
gt; minxy11
gt; ------------------------------------------------------------------------
gt; minxy11's Profile: www.excelforum.com/member.php...oamp;userid=32848
gt; View this thread: www.excelforum.com/showthread...hreadid=526631
gt;
gt;

With a Pivot Table you could sum up the sales for all your people at once.
I do this all the time for our sales force. I also sum up sales by
customer. It's really fast and easy.

--
Carlos

quot;minxy11quot; gt; wrote in
message ...
gt;
gt; hi, i am wanting to use vlookup and sum funtion together but dont know
gt; how, i am using a table for transactions (employee names and prices).
gt; what i want to do is search the transactions and add up the total sales
gt; per person.
gt; thanks
gt;
gt;
gt; --
gt; minxy11
gt; ------------------------------------------------------------------------
gt; minxy11's Profile:
www.excelforum.com/member.php...oamp;userid=32848
gt; View this thread: www.excelforum.com/showthread...hreadid=526631
gt;