Lookup and Sum in same cell

[Potatosalad2]

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

 

[shternm]

SUMIF should work for you.

 

[Potatosalad2]

Thank you for your help.

Now how can I get a list of SHNAME without duplicates

 

[Bob Phillips]

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

HTH
Bob

"Potatosalad2" <[email protected]>
wrote in message
news[email protected]...

 

[Zack Barresse]

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

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


"Potatosalad2" <[email protected]>
wrote in message
news[email protected]...

 

[Potatosalad2]

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