Ref and list unique names and sum their corresponding training hours that accumulate

[jcth81]

Hello and thank all in advance for any help. Just registered and seems like a potential great resource....

I need to enter and track training hours for individuals that accumulate over time.

I am starting a spreadsheet where I enter a date (col A); indivudual's name (col B); hours Class Training (col C); and hours Field Training (col D); as individuals accumulate training.

I would like to then have a function on a another sheet if posssible that references and lists these unique names once (as the same names will be entered multiple times as they accumulate training hours on different dates); and also sum their hours. Thus having an ongoing function updating and summing hours for individuals as I input their info.

Any suggestions, thank you.

Attached is what I have started...

Sincerely,
J.

[FDibbins]

without seeing a sample workbook, try playing around with sumifS()

[Blake 7]

As per your post for the column setup. T

then to caputure your requirement in G1 type Unique Name in H1 type Hrs Class Training in I1 type Hrs Field Training.
then in H2

Please Login or Register  to view this content.

drag across and down.

Dont forget to put your unique names in G2:Gwhatever

[tigeravatar]

jcth81,

Welcome to the forum!
Attached is a modified version of the posted file showing both a pivot table solution and a formula solution in Sheet2. In Sheet1, I converted the raw data to be a table (select the data -> Insert -> Table). When you type in new data directly underneath the table, the table will automatically extend to pick up that data. This allows both shown solutions to update dynamically (though you'll need to right-click on the pivot table and select refresh, and also make sure the formula solution is copied down far enough to pick up the full list of unique names. It is currently only copied down to row 9).