K
Kevin
I hope someone can help solve my problem.
I have a row of data with tasks, then in the following row
I have job codes that match to each of those tasks. (eg,
Admin, PH) For the rows after that, I have the date at the
top and then a value assigned to each of the tasks/job
codes to show how much time was spent on each.
What I'm trying to do is a tally at the end of each day
that says, "Search through cells B10:B250. When you find
one that says 'Admin' then add the time spent on 7/21 to
the Tally." I want to do that for every day and every job
code.
Thanks,
-Kevin.
I have a row of data with tasks, then in the following row
I have job codes that match to each of those tasks. (eg,
Admin, PH) For the rows after that, I have the date at the
top and then a value assigned to each of the tasks/job
codes to show how much time was spent on each.
What I'm trying to do is a tally at the end of each day
that says, "Search through cells B10:B250. When you find
one that says 'Admin' then add the time spent on 7/21 to
the Tally." I want to do that for every day and every job
code.
Thanks,
-Kevin.