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

wmichael

Board Regular
Joined
Aug 26, 2014
Messages
113
Office Version
  1. 365
  2. 2019
  3. 2007
Platform
  1. Windows
  2. Mobile
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>
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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)
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
Maybe


Excel 2013/2016
ABCDEF
1WhoHours trackingNameTotals
2Alejandro Grand2Alejandro Grand2
3Alicia Gibbs2Alicia Gibbs6
4Alicia Gibbs4Amaury Sainvil2
5Amaury Sainvil2Amin Farschchi4
6Amin Farschchi2Anthony Moore10
7Amin Farschchi2Ariel Diaz2
8Anthony Moore2Avril Cherasard2
9Anthony Moore2Beatriz Rocha2
10Anthony Moore2Belkis E Torres L6
11Anthony Moore2Brian Robaina2
12Anthony Moore2Carlos Lopez2
13Ariel Diaz2Carlos Moreno4
14Avril Cherasard2Carolina Mendoza2
15Beatriz Rocha2Chris Sarraco2
16Belkis E Torres L4
17Belkis E Torres L2
18Brian Robaina2
19Carlos Lopez2
20Carlos Moreno4
21Carolina Mendoza2
22Chris Sarraco2
Sheet1
Cell Formulas
RangeFormula
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)
 
Upvote 0

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top