Vlookup and SUM

M

minxy11

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
 
D

Damon Longworth

Have a look at SumIf in help.

=SUMIF(NameRange,Name,SalesRange)

--
Damon Longworth

2006 UK Excel User Conference
July 19/21st, 2006
University of Westminster - Marylebone Campus
London, England
Early Bird Registration Now Open!!
http://www.exceluserconference.com/2006UKEUC.html

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
It's not too late to register!
http://www.exceluserconference.com/2006ECEUC.html


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
 
B

Biff

Hi!

See if this is what you're after:

Column A = names
Column B = price

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

Biff
 
S

Sridhar V

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,"B",B:B)

I Hope this will help you.

Sridhar
 
C

CarlosAntenna

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