Hi Everyone!
I'm working on a spreadsheet where everyone's work hours are tied to the project he or she is working on. For example, I have the name of the person in Column D, and Column R is the hours billed to the job. The hours billed to the job comes from a list at the bottom of the spreadsheet which is linked to another spreadsheet and is updated monthly. This data is found in Column B, Rows 40-59, with each row the number of hours each person worked.
Here is the formula I'm using: =IF(D4="Sean Mahoney",B44,IF(D4="Brad Stabenow",B45,IF(D4="Nicole Anderson",B41,IF(D4="Matt Huderski",B43,IF(D4="Shea Groom",B42,IF(D4="James Sherry",B52))))))
The very first row under PM Hours Billed to Jobs is correct. None of the others are. Is there a better formula to use? I copied and pasted my spreadsheet below because I couldn't figure out to insert a link. If anyone can help me out, I'd greatly appreciate it.
Thank you!
Darleen
<tbody>
</tbody>
I'm working on a spreadsheet where everyone's work hours are tied to the project he or she is working on. For example, I have the name of the person in Column D, and Column R is the hours billed to the job. The hours billed to the job comes from a list at the bottom of the spreadsheet which is linked to another spreadsheet and is updated monthly. This data is found in Column B, Rows 40-59, with each row the number of hours each person worked.
Here is the formula I'm using: =IF(D4="Sean Mahoney",B44,IF(D4="Brad Stabenow",B45,IF(D4="Nicole Anderson",B41,IF(D4="Matt Huderski",B43,IF(D4="Shea Groom",B42,IF(D4="James Sherry",B52))))))
The very first row under PM Hours Billed to Jobs is correct. None of the others are. Is there a better formula to use? I copied and pasted my spreadsheet below because I couldn't figure out to insert a link. If anyone can help me out, I'd greatly appreciate it.
Thank you!
Darleen
Job # | Closed | Job Name | Project Manager | Superintendent | PM Hours Billed To Jobs | Supt Hours Billed To Jobs | |
2016-474 | RMR US Treasury TI | Sean Mahoney | James Martin | 5.00 | 10.00 | ||
2016-495 | CRMC Dialysis Addition | Brad Stabenow | Dan Ozborn | 7.00 | 12.00 | ||
2016-496 | Swope OBGYN & Pediatric | Nicole Anderson | Troy McKitrick | 4.00 | 11.00 | ||
2017-497 | Sean Mahoney | Derrick Shanks | 8.00 | 17.00 | |||
2017-509 | Matt Huderski | James Sherry | 8.00 | 13.00 | |||
2017-511 | Matt Huderski | Troy McKitrick | 9.00 | 11.00 | |||
2017-513 | Shea Groom | John Alexander | 9.00 | 8.00 | |||
2017-518 | Nicole Anderson | James Sherry | 9.00 | 13.00 | |||
2017-520 | Sean Mahoney | Jake Lawson | 13.00 | 15.00 | |||
2017-523 | Sean Mahoney | James Martin | 14.00 | 10.00 | |||
2017-527 | Nicole Anderson | Mitch Welty | 12.00 | 14.00 | |||
2017-529 | Brad Stabenow | Gus Purdum | 17.00 | 20.00 | |||
2017-531 | Matt Huderski | Aaron Hankammer | 16.00 | 7.00 | |||
2017-532 | James Sherry | James Sherry | 0.00 | 13.00 | |||
2017-533 | Shea Groom | John Alexander | 17.00 | 8.00 | |||
2017-534 | Nicole Anderson | 17.00 | |||||
2017-535 | Sean Mahoney | James Martin | 0.00 | 10.00 | |||
2017-536 | Matt Huderski | 0.00 | |||||
2017-537 | Shea Groom | 0.00 | |||||
2017-538 | Brad Stabenow | 0.00 | |||||
2017-539 | Matt Huderski | 0.00 | |||||
2017-540 | James Sherry | James Sherry | 0.00 | 13.00 | |||
2017-541 | Shea Groom | Aaron Hankammer | 0.00 | 7.00 | |||
2017-542 | Shea Groom | Aaron Hankammer | 0.00 | 7.00 | |||
2017-543 | Matt Huderski | Troy McKitrick | 0.00 | 11.00 | |||
2017-544 | Nicole Anderson | 0.00 | |||||
2018-545 | Nicole Anderson | James Sherry | 0.00 | 13.00 | |||
Hrs to Jobs | |||||||
Don | 1.00 | ||||||
Nicole | 2.00 | ||||||
Shea | 3.00 | ||||||
Matt | 4.00 | ||||||
Sean | 5.00 | ||||||
Brad | 6.00 | ||||||
Aaron | 7.00 | ||||||
John | 8.00 | ||||||
Bob | 9.00 | ||||||
James M | 10.00 | ||||||
Troy | 11.00 | ||||||
Dan | 12.00 | ||||||
James S | 13.00 | ||||||
Mitch | 14.00 | ||||||
Jacob L | 15.00 | ||||||
Jeffrey M | 16.00 | ||||||
Derrick | 17.00 | ||||||
Jacob A | 18.00 | ||||||
Jeff P | 19.00 | ||||||
Gus | 20.00 |
<tbody>
</tbody>