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!
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!