Adding Like Cells

  • Thread starter Thread starter matthew
  • Start date Start date
M

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
 
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 **
 
Back
Top