Excel Vlookup and sumif function maybe a macro issue?

Jul 24, 2017
Reaction score

Here's the problem that I need to solve. There will be workers that put in their hours and task for every day of the week and I need them need the "task" and the "worker" to go over into the "project summary" and then the hours for all of the weeks to be summed up. That way the project manager can get a sum of what is essentially total hours spent by each worker for each task across all weeks. I was thinking of just doing it with formulas (like a vlookup combined with sumif) I have the "worker" and the "task" set up as data validation lists so I really just need those hours to auto-populate. Any help would be appreciated.


  • Capture 3.PNG
    Capture 3.PNG
    34.8 KB · Views: 84


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question