=SUMIF(A1:A20,"Bob",B1:B20)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
Bob 1
Bob 3
Jill 2
Jill 1

How do I get excel to calculate the total value for Bob and Jill. I have
tried index, but cannot get the formula correct.