PDA

View Full Version : [SOLVED] Sum Values Assigned to a Name



boccuz
01-28-2018, 04:52 PM
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
01-28-2018, 07:04 PM
It'd be easier if you posted a small workbook with some sample data

SamT
01-29-2018, 04:32 AM
=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
01-29-2018, 05:29 AM
Thanks Sam T. This now works. Appreciate everyone's help!