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

wmichael

Board Regular
Joined
Aug 26, 2014
Messages
71
Hello. Seeking a formula to add up all the hours worked by each volunteer. Thank you.

WhoHours tracking
Alejandro Grand2
Alicia Gibbs2
Alicia Gibbs4
Amaury Sainvil2
Amin Farschchi2
Amin Farschchi2
Anthony Moore2
Anthony Moore2
Anthony Moore2
Anthony Moore2
Anthony Moore2
Ariel Diaz2
Avril Cherasard2
Beatriz Rocha2
Belkis E Torres L4
Belkis E Torres L2
Brian Robaina2
Carlos Lopez2
Carlos Moreno4
Carolina Mendoza 2
Chris Sarraco2
Christopher Pineda12
Christopher Pineda2
Christopher Shoukry2
Chuck Ellis2
Claudia Aqhomes2
Claudia Aqhomes2
Cristian Cruz2
Cristiano Oliva2
Cuindney Mantilla2
Dan Spinner12
Dan Spinner12
David Allen2
Denise Ford2
Dennis Dalacio2
Dennis Dalacio2
Dmitri Sinilnikov2
Dmitri Sinilnikov2
Domenick Broche2
Drew Christman2
Ekaterina Khayrulina2
Elena Espino2
Elizabeth Hendricks2
Eva Porro2
Fabiana Navas2
Fireley Sandoval4
Francesca Grandinetti2
Gerardo Maeso2
German Rubi2
German Rubi2
German Rubi2
Gino Fernandez2
Glafe Ruiz Sanchez2
Hanna Bazzi2
Hanna Bazzi2
Ibrahim N Tansel2
Ivette Klein4
Javier Pedraza-Mena2
Jayda-Skye Sainvil2
Jeff Acacio2
Jeff Acacio4
Jeff Acacio2
Jeremy Bary2
Jeremy Bary2
jessica Buhl2
jessica Buhl2
Jim Klotz2
Jocelyn Issayeva4
John Costanzo2
Jonah Levin2
Jorge & Minerva Nunez4
Jorge Cruz2
Jose Godoy4
Jose Godoy4
Jose Godoy4
Jose Godoy2
Kameron Senemar2
Kenneth Schanzer2
Key Club Group 14
Key Club Group 14
Kirsten Corssen12
Kirsten Corssen12
Kristen Markovich2
Kristen Markovich2
Kristina Vega2
Lenuam Garcia2
Lisa Hernandez2
Loris Porras2
Luis L Aguilar2
Maija Fears2
Maria Perez2
MARITZA J DIAZ2
Marla Cummings2
Marlene Marin2
Marlene Marin4
Martin Lares2
Marvel Waters2
Mauricio Arauz2
Mayra Fernandez2
Mayra Fernandez2
Melody Torrens2
Michelle Kostowic2
Michelle Kostowic2
Michelle Kostowic2
Monique Graciotti4
Nazario Ruiz Sanchez2
Patricia Paparoni2
phavel Ramirez2
Reinol Sotolongo2
Richard Leiva2
Richard Leiva2
Robert Hendricks2
Robert Hendricks2
Roman Sanchez2
Romina Benesch2
Romina Benesch2
Ronald Rojas2
Rosa Labarile4
Ryan Wood12
Ryan Wood12
Salomon Muci2
Sandra Brown12
Sandra Brown12
Seleste Arauz2
Sidle Roldan2
Sofia Gomez2
Stoyan Dichev2
Stoyan Dichev2
Suzanne M Hendricks2
Todd Marrazzo4
Tomas Marca2
Tori Hendricks2
Victor Aromin4
VICTOR ROIZNER4
William Allen2
William Freeman2
Yanick Jeanty2
Yaynaru Morales2
Zeynep A. Talu-Balci2

<colgroup><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Barbados

New Member
Joined
Mar 14, 2019
Messages
4
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

Well-known Member
Joined
Oct 30, 2014
Messages
4,192
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
try

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

alpadem

New Member
Joined
Oct 9, 2018
Messages
15
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

New Member
Joined
Mar 14, 2019
Messages
4
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,655
Office Version
  1. 365
Platform
  1. Windows
Maybe

<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="font-weight: bold;;">Who</td><td style="font-weight: bold;;">Hours tracking</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name</td><td style=";">Totals</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Alejandro Grand</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Alejandro Grand</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Alicia Gibbs</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Alicia Gibbs</td><td style="text-align: right;;">6</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Alicia Gibbs</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Amaury Sainvil</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Amaury Sainvil</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Amin Farschchi</td><td style="text-align: right;;">4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Amin Farschchi</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Anthony Moore</td><td style="text-align: right;;">10</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Amin Farschchi</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Ariel Diaz</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Anthony Moore</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Avril Cherasard</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">Anthony Moore</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Beatriz Rocha</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Anthony Moore</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Belkis E Torres L</td><td style="text-align: right;;">6</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">Anthony Moore</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Brian Robaina</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style=";">Anthony Moore</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Carlos Lopez</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style=";">Ariel Diaz</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Carlos Moreno</td><td style="text-align: right;;">4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style=";">Avril Cherasard</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Carolina Mendoza</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style=";">Beatriz Rocha</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Chris Sarraco</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style=";">Belkis E Torres L</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style=";">Belkis E Torres L</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style=";">Brian Robaina</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style=";">Carlos Lopez</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style=";">Carlos Moreno</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style=";">Carolina Mendoza</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style=";">Chris Sarraco</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E2</th><td style="text-align:left">=IFERROR(<font color="Blue">INDEX(<font color="Red">$A$2:$A$22,MATCH(<font color="Green">0,INDEX(<font color="Purple">COUNTIF(<font color="Teal">E$1:E1,$A$2:$A$22</font>),0</font>),0</font>)</font>),""</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F2</th><td style="text-align:left">=SUMIF(<font color="Blue">A:A,E2,B:B</font>)</td></tr></tbody></table></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,109,537
Messages
5,529,426
Members
409,876
Latest member
Akash Yadav
Top