How to merge similar data

LOOKUP wont work, it just looks up one value.
Pivot table would be best but prob complicated to use.

Type the names once only in a new sheet in column A, say Sheet 2

in Sheet2!B1
=SUMIF(Sheet2!A1,Sheet1!$A$1:$A$1000,Sheet1!$B$1:$B$1000)

Adjust the 1000 for however many rows there are

One solution possibility: Sort on the name. Use the subtotal function found in 2003 on the Data Tab.

Here is a tutorial: http://www.youtube.com/watch?v=X5w5uWJDct8

In that case, the already mentioned, pivot table will also work.

Originally Posted by Special-K

LOOKUP wont work, it just looks up one value.
Pivot table would be best but prob complicated to use.

Type the names once only in a new sheet in column A, say Sheet 2

in Sheet2!B1
=SUMIF(Sheet2!A1,Sheet1!$A$1:$A$1000,Sheet1!$B$1:$B$1000)

Adjust the 1000 for however many rows there are

There may be something missing because your formula picks up only one value, say if I have three values for Robert, it does not pick up the other two.

I don't understand. Please post an example of what you are trying to do.

Based on the sample you provided, try this in column C, copied down - adjust ranges as needed...
=IF(COUNTIF($A$1:A1,A1)>1,"",SUMIF($A$1:$A$9,A1,$B$1:$B$9))

I am trying to do something similar.
I have a spreadsheet I use at work with a different worksheet for each day displaying what the staff have achieved and a sheet for a weekly total, bearing in mind that the staff can vary from day to day.
How can I merge the data from all the other sheets in to the weekly total sheet to show the total productivity for that week?

Here is a simple example of what I am trying to achieve..

help.jpg

And here is the file..

help.xls


Cheers guys!

Hi hello its Dean
Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.