Adding Like Cells

[matthew]

Column A is security name, Column B is Qty: If security
name is the same, how can I get the qty to sum into one
cell?
A B C

MATT 5 =18
MATT 8
MATT 5
SUE 6 =13
SUE 7
PETE 1 =6
PETE 2
PETE 3

 

[Paul B]

Matthew, try something like this =SUMIF($A$1:$A$25, "=MATT", $B$1:$B$25)

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **