Need formula

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

Assuming your table of Tasks, Who, and Hours begins at A1 and your Total
Hours summary begins at A9, put the following in B10 and copy:

=SUMIF($B$2:$B$5,"="&$A10,$C$2:$C$5)
 
I need help building a formula. What I want to do is list
tasks in a column; then enter the name of an employee with
an associated number of hours that I want that employee to
work on that task in the adjacent column and row. Then I
want to be able to total the hours that the employee has
worked. So, I need to build a formula in the cell beside
the employees name that will look for the employees name
in the "who" column, then total the hours that the
employee actually worked. Any help is appreciated.

Ken


Tasks Who Hours
Task 1 Jeff 5
Task 2 Mike 3
Task 3 Jeff 3
Task 4 Mike 3
Mike 2


Total Hours
Jeff
Mike
 
Back
Top