In sheet 1 I have two columns:

Column A has a list of 10 entries of 4 different people, randomly
repeating.

(Bob, Sally, Bob, Dave, Sarah, Sally, Sarah, Bob, Sally, Bob)

Column B has random values for each entry

(10, 13, 50, 56, 100, 250, 20, 35, 60, 25)

I have applied the autofilter so that I am able to see the 'values' for
each person.

In sheet 2 I have two columns:

Column A with 4 entries of the 4 people sheet 1 is concerned with.

(Bob, Sally, Dave, Sarah)

In column B of sheet 2, I want totals to appear for each person by
summing the values that appear for each in sheet 1. (i.e. 120 for Bob)

I'm thinking it's got something to do with vlookup but that's as far as
i got!

Any help is much appreciated!

Thanks


--
choc_penguin
------------------------------------------------------------------------
choc_penguin's Profile: http://www.excelforum.com/member.php...o&userid=30099
View this thread: http://www.excelforum.com/showthread...hreadid=507936