Sum Values Assigned to a Name

[boccuz]

Hello,

I have a spreadsheet that have list tasks, assigns a name to the task, and estimated hours to complete task. Individuals can be assigned to multiple tasks. I would like to sum the total of hours an individual has assigned to them. There may be multiple individuals assigned to a single task. I tried using sumif as follows =SUMIF(LOSAP!F:F,LOSAP!C:C="*Individuals last name, First*") Column F contains the estimated hours and Column C contains each individual name. Any help is greatly appreciated. Thanks!

[Paul_Hossler]

It'd be easier if you posted a small workbook with some sample data

[SamT]

=SUMIF(LOSAP!F:F,LOSAP!C:C="*Individuals last name, First*")

=SUMIF(LOSAP!C:C,"*Individuals last name, First*",LOSAP!F:F)

Alternately Replace "*Individuals last name, First*" With a cell reference.

For example, Say that on sheet 1, you have a list of *LastName, FirstName* in column A, In Column B, Row 1, use the formula

=SUMIF(LOSAP!C:C,A1, LOSAP!F:F)

SumIf(EvaluateRange, EvaluateValue, SumRange)
SumIf(NameList, Name, HoursList)

[boccuz]

Thanks Sam T. This now works. Appreciate everyone's help!