Index to determine total of values

B

Brian

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.
 
B

Bob Phillips

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

--

HTH

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