I have a timesheet that I've been working on. Here's my problem. I use this
code to look up the amount of time recorded for each job worked on a
particular day.
=IF(ISNA(VLOOKUP(Year!$O2,$A$5:$M$11,13,FALSE)),,( VLOOKUP(Year!O2,$A$5:$M$11,13,FALSE)))
Year!O contains a list of jobs for each week. This works great however
sometimes an employee will work on the same job at different times of the
day. This code only returns the first time found. I need it to add all the
hours for the same job worked ($A$5:$M$11,13).
Is there an adjustment I can make to accomplish this?

Maybe using =sumif() would help.

Debra Dalgleish has lots of notes:
http://contextures.com/xlFunctions01.html#SumIf

smonsmo wrote:

I have a timesheet that I've been working on. Here's my problem. I use this
code to look up the amount of time recorded for each job worked on a
particular day.
=IF(ISNA(VLOOKUP(Year!$O2,$A$5:$M$11,13,FALSE)),,( VLOOKUP(Year!O2,$A$5:$M$11,13,FALSE)))
Year!O contains a list of jobs for each week. This works great however
sometimes an employee will work on the same job at different times of the
day. This code only returns the first time found. I need it to add all the
hours for the same job worked ($A$5:$M$11,13).
Is there an adjustment I can make to accomplish this?

--

Dave Peterson