Formula help  summarize hours per person in plan
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 😅
Answers

It should be something like this (Range to Sum, Criteria Range, Criteria):
=SUMIFS([Hours]:[Hours], [Assigned To]:[Assigned To], [Assigned To]@row)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!