Seeking a formula to add up all the hours worked by each volunteer

[wmichael]

Hello. Seeking a formula to add up all the hours worked by each volunteer. Thank you.

[TABLE="width: 317"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Who[/TD]
[TD]Hours tracking[/TD]
[/TR]
[TR]
[TD]Alejandro Grand[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Alicia Gibbs[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Alicia Gibbs[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Amaury Sainvil[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Amin Farschchi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Amin Farschchi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Anthony Moore[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Anthony Moore[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Anthony Moore[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Anthony Moore[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Anthony Moore[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Ariel Diaz[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Avril Cherasard[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Beatriz Rocha[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Belkis E Torres L[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Belkis E Torres L[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Brian Robaina[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carlos Lopez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carlos Moreno[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Carolina Mendoza [/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Chris Sarraco[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Christopher Pineda[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Christopher Pineda[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Christopher Shoukry[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Chuck Ellis[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Claudia Aqhomes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Claudia Aqhomes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Cristian Cruz[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Cristiano Oliva[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Cuindney Mantilla[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Dan Spinner[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Dan Spinner[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]David Allen[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Denise Ford[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Dennis Dalacio[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Dennis Dalacio[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Dmitri Sinilnikov[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Dmitri Sinilnikov[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Domenick Broche[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Drew Christman[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Ekaterina Khayrulina[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Elena Espino[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Elizabeth Hendricks[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Eva Porro[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Fabiana Navas[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Fireley Sandoval[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Francesca Grandinetti[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Gerardo Maeso[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]German Rubi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]German Rubi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]German Rubi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Gino Fernandez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Glafe Ruiz Sanchez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Hanna Bazzi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Hanna Bazzi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Ibrahim N Tansel[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Ivette Klein[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Javier Pedraza-Mena[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jayda-Skye Sainvil[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jeff Acacio[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jeff Acacio[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Jeff Acacio[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jeremy Bary[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jeremy Bary[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]jessica Buhl[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]jessica Buhl[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jim Klotz[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jocelyn Issayeva[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]John Costanzo[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jonah Levin[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jorge & Minerva Nunez[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Jorge Cruz[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jose Godoy[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Jose Godoy[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Jose Godoy[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Jose Godoy[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Kameron Senemar[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Kenneth Schanzer[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Key Club Group 1[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Key Club Group 1[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Kirsten Corssen[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Kirsten Corssen[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Kristen Markovich[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Kristen Markovich[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Kristina Vega[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Lenuam Garcia[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Lisa Hernandez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Loris Porras[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Luis L Aguilar[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Maija Fears[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Maria Perez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]MARITZA J DIAZ[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Marla Cummings[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Marlene Marin[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Marlene Marin[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Martin Lares[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Marvel Waters[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Mauricio Arauz[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Mayra Fernandez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Mayra Fernandez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Melody Torrens[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Michelle Kostowic[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Michelle Kostowic[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Michelle Kostowic[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Monique Graciotti[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Nazario Ruiz Sanchez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Patricia Paparoni[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]phavel Ramirez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Reinol Sotolongo[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Richard Leiva[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Richard Leiva[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Robert Hendricks[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Robert Hendricks[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Roman Sanchez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Romina Benesch[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Romina Benesch[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Ronald Rojas[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Rosa Labarile[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Ryan Wood[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Ryan Wood[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Salomon Muci[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sandra Brown[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Sandra Brown[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Seleste Arauz[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sidle Roldan[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sofia Gomez[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Stoyan Dichev[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Stoyan Dichev[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Suzanne M Hendricks[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Todd Marrazzo[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Tomas Marca[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Tori Hendricks[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Victor Aromin[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]VICTOR ROIZNER[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]William Allen[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]William Freeman[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Yanick Jeanty[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Yaynaru Morales[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Zeynep A. Talu-Balci[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[Barbados]

You could just turn the table in to a pivot table and it will give you a list of single no duplcate names and the hours added up for each or

Create a list of the names with no dublicates:
Copy the name column to another column, select that duplcated list and on the excel tab DATA use the 'Remove Duplicates' option.
Next to that shortened list enter the formula =SUMIF(A:A,E:E,B:B)

 

[AlanY]

try

=SUMIF(A:A,"name",B:B)

 

[alpadem]

First You need to make list unique, than use

=SUMIFS($B$2:$B$140 (First list hours tracking) ,$A$2:$A$140 (first list who),G2 (unique list's first name) then copy and paste below.

 

[Barbados]

should have mentioned
Assumed names are in col A,and hours in col B, I placed the duplicated names list in col E and the formula in col F.

 

[Fluff]

Maybe

Excel 2013/2016
	A	B	C	D	E	F
1	Who	Hours tracking			Name	Totals
2	Alejandro Grand	2			Alejandro Grand	2
3	Alicia Gibbs	2			Alicia Gibbs	6
4	Alicia Gibbs	4			Amaury Sainvil	2
5	Amaury Sainvil	2			Amin Farschchi	4
6	Amin Farschchi	2			Anthony Moore	10
7	Amin Farschchi	2			Ariel Diaz	2
8	Anthony Moore	2			Avril Cherasard	2
9	Anthony Moore	2			Beatriz Rocha	2
10	Anthony Moore	2			Belkis E Torres L	6
11	Anthony Moore	2			Brian Robaina	2
12	Anthony Moore	2			Carlos Lopez	2
13	Ariel Diaz	2			Carlos Moreno	4
14	Avril Cherasard	2			Carolina Mendoza	2
15	Beatriz Rocha	2			Chris Sarraco	2
16	Belkis E Torres L	4
17	Belkis E Torres L	2
18	Brian Robaina	2
19	Carlos Lopez	2
20	Carlos Moreno	4
21	Carolina Mendoza	2
22	Chris Sarraco	2
Sheet1

Cell Formulas
Range	Formula
E2	=IFERROR(INDEX($A$2:$A$22,MATCH(0,INDEX(COUNTIF(E$1:E1,$A$2:$A$22),0),0)),"")
F2	=SUMIF(A:A,E2,B:B)