Total Hours with the same person assigned

Joechaptaylor

I have created the below sheet.

I am trying to total the hours used for rows matching "person"

E.G In the first row "Richard Irwin @ FM" I'm looking to total the rows below Project Staffing that have Richard attached to it in the column "Person"

Any ideas?

David Tutwiler

This formula should do it:

=SUMIF(Person6:Person100, Person@row, [Total Hours]6:[Total Hours]100)

You may have to adjust the ranges based on how long the sheet is you are looking at.

David Tutwiler

This formula should do it:

=SUMIF(Person6:Person100, Person@row, [Total Hours]6:[Total Hours]100)

You may have to adjust the ranges based on how long the sheet is you are looking at.

Joechaptaylor

Thank you, that works!

David Tutwiler

Awesome, great to hear.