Job for VLOOKUP?

  • Thread starter Thread starter Guest3731
  • Start date Start date
G

Guest3731

I'm trying to make a spreadsheet that will double as a timesheet for
work as well as a way of keeping track of how much time is spent on
each of several different projects throughout the day.

Columns A through C are time in, time out, and total time. These are
no problem. Column D is where I'd like to enter a project code, like
ABC or DEF. columns E through J, say, are the issue. I'd like to
label them at the top with project codes, ABC for instance, and for a
given row, say, row 1, I'd like to carry over a row's value to the
corresponding column for summation. That is, if cells C3 and D3
contain "1.0" and "ABC", I'd like cell E3 to also contain "1.0", such
that the sum of column E contains all of that day's entries that are
marked "ABC". Does this make sense? I'm not sure if I can use a
VLOOKUP for this, or perhaps just a complicated set of IFs in each
cell of columns E-J.

Any help would be greatly appreciated.
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
I would think you could do it row by row like so in E3 then copied down:

=IF($D3 = C$1, C3, "")

Then you can sum the values in each column.
==========

To do it all in one cell, then a SUMIF() should work:

=SUMIF($D$2:$D$30, C$1, $C$2:$C$30)
 
Back
Top