Formula help - summarize hours per person in plan

Cecilie

Hi all

I found an old post which has the same problem as I do. However, I can't get my head around the formula presented as a solution in the original post, so I need some help 😅

I want to summarize hours per person per project. Each project has all people listed at the top of the plan, so I wanted to use these rows and a formula to summarize hours of an 'hours' column. I want to eventually gather all hours per person in a report.

The formula presented is this:

=SUMIF([Assigned To]:[Assigned To], [Assigned To] = [Assigned To]@row, [Hours]:[Hours])

…Or some alternative of this. However, I cannot grasp where I am supposed to input the name of my hours column, and where I input the person I am trying to get the hours of? I have tried different things, but it always returns Unpareseable.

I am very lost with formulas, so any help os much appreciated 😅

Nic Larsen

It should be something like this (Range to Sum, Criteria Range, Criteria):

=SUMIFS([Hours]:[Hours], [Assigned To]:[Assigned To], [Assigned To]@row)