Need to calculate a total from a range of cells on different sheets

Hello,
I am new to this, so i appreciate your patience and help in advance! I have a file that I need to have PTO hours calculated. I have attached the file.
Basically, people (joe, susy, griffin, tom, etc) will enter their PTO hours in the month and day that they will be taking it. There will be seperate sheets for each month of the year (my file currently only has July and August). I want the total PTO hours per person added together and seen on a seperate sheet within the workbook (PTO_Totals).
I have tried several nested IF formulas that ended up being too cumbersome, and I don't know enough about VBE to create a macro.
Please help. Thank you!

Sample.xlsx

Hello jrosko1 ,

Welcome to the Forum!

It looks like columns "L:W" are not being used. I say that because the formula in column "K" will display FULL if columns "E:J" of the same row contain entries. Do plan on using these columns (L:W) later on?

Hello jrosko1,

Thanks, that won't be a problem.

Hello jrosko1,

I always seem to get phone calls when I am writing code. I moved the named range "NAME" from the "Dropdowns" sheet to the "PTO_Totals" sheet and made it dynamic. Now if you add or delete names the range adjusts automatically. A button was added to the "PTO_Totals" sheet to run the macro below.

Please Login or Register  to view this content.

That is awesome, thanks Leith Ross! I love the button, great stuff. And it functions perfectly like it's supposed to.... I have just one request. The dropdowns for columns E, G, I, L, N, P, R, T, V are not populating any names at this point? Is it possible to update to have the names show up, even if the list gets modified. I tried messing around with it, but am only receiving errors

Hello jrosko1,

You can select all the cells with drop downs on the sheet and reset the Validation List to point to "NAME" by typing in "=NAME" at the bottom of the validation dialog.

Hello jrosko1,

The problem was the with the formula for the "NAME". That was my fault. It was using relative addressing instead of absolute. Here is how it should appear...

=OFFSET(PTO_Totals!$A$1,1,0,COUNTA(PTO_Totals!$A:$A)-1, 1)

The attached workbook has the change made to it.

Hello jrosko1,

You're welcome. Glad I could help.