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