Adding data from specific names ugh!!

[jayclinton]

I have a sheet that has the same employee names several times in different orders in the same column with data to the right of it.Example

Name.......Pieces...hrs
.....A........B........C
(1)John...1000......12
(2).........2000......20
(3)Jay.....2000......31
(4).........2500.....20
(5)John...2000.....50
(6).........5000.....60
(7)Bill......1200.....40
(8)..........3000.....60

I need the peices and hours total for each name on another sheet.

So I would have John on my sheet and would need to to grab and add the info from B2 & B6 into one cell (since it is the same person). I can always drag the info over for hours once I find a way to do this for the pieces I would think. The problem is that I don't want to add in B1 & B2 for John because those numbers are not a part of the total.

So is there a way or formula for one cell to look at the entire sheet and everytime it sees the name john to add the information one column over and one cell down and then give a total?

I may be able to do some formatting and have all the info I need directly to the right. So I would have (A1) John, (B1) Data, (C1) Data. The issue would be a cell finding the name, taking the information directly to the right of it and adding it as many times as the name is found on the sheet.

I appreciate the help.

Jay

[teylyn]

Is the blank cell in column A always supposed to be the name in the cell above? If so, you could insert a column between A and B and in the new B column put the following formula:

in B1 put

=A1

in B2 put
=if(ISBLANK(A2),B1,A2)

copy this formula down the complete column.

Next, set up a pivot table for your data from column B to D to sum up values for each person.

HTH

[NBVC]

If the list of unique names is in say cells F2 and downwards, then try:

=SUMIF($A$2:$A$9,F2,OFFSET($C$2:$C$9,1,0))

where your original data is in A2:C9 and the first name, say John, is in F2

Copy formula down.

[jayclinton]

Fantastic!!!! That worked great. You're the best. Thanks!!!!!!

[jayclinton]

Thanks NBVC! That worked perfect.

[NBVC]

Please indicate which solution you used and then please mark your thread as solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save