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.