Lookup and Sum in same cell
 

SHNAME ENTDATE SYMBOL QTY RATE COMM
C78 1/24/2005 CSCO 1100 0.018 $20
C78 1/28/2005 CSCO -5439 0.018 $100
C78 2/23/2005 CSCO 50 0.017 $1
C78 4/5/2005 CSCO -7892 0.018 $140
C78 4/13/2005 CSCO 3786 0.018 $69

I am trying to create a lookup formula that will search by SHNAME, find
each entry and sum the COMM column in one cell:

SHNAME COMM
C78 $360

This worksheet is thousands of rows long with multiple rows for each
SHNAME.
Thanks in advance


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=472705

SUMIF should work for you.


--
shternm
------------------------------------------------------------------------
shternm's Profile: http://www.excelforum.com/member.php...nfo&userid=858
View this thread: http://www.excelforum.com/showthread...hreadid=472705

Thank you for your help.

Now how can I get a list of SHNAME without duplicates?


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=472705

=SUMIF(A:A,"C78",C:C)

HTH
Bob

"Potatosalad2"
wrote in message
news:Potatosalad2.1wc8me_1128362724.8386@excelforu m-nospam.com...

SHNAME ENTDATE SYMBOL QTY RATE COMM
C78 1/24/2005 CSCO 1100 0.018 $20
C78 1/28/2005 CSCO -5439 0.018 $100
C78 2/23/2005 CSCO 50 0.017 $1
C78 4/5/2005 CSCO -7892 0.018 $140
C78 4/13/2005 CSCO 3786 0.018 $69

I am trying to create a lookup formula that will search by SHNAME, find
each entry and sum the COMM column in one cell:

SHNAME COMM
C78 $360

This worksheet is thousands of rows long with multiple rows for each
SHNAME.
Thanks in advance


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile:
http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=472705

You could use AdvancedFilter | Unique Values for a unique list without
duplicates.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"Potatosalad2"
wrote in message
news:Potatosalad2.1wcbed_1128366322.5111@excelforu m-nospam.com...

Thank you for your help.

Now how can I get a list of SHNAME without duplicates?


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile:
http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=472705

These suggestions work perfectly. Thank you all very much for your
help!!


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=472705