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