Need formula

[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)

 

[ken]

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

 

[Frank Kabel]

Hi
a formula approach
=SUMIF(B1:B100,"Jeff",C1:C100)
and format the resulting cell with the custom format
[hh]:mm
you can eplace the search string "Jeff" with a cell reference. e.g.
=SUMIF(B1:B100,D1,C1:C100)
where D1 stores your employee's name

you may consider using a pivot table for this. Have a look at
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html