Sum of Row if Row Meets Certain Criteria

Hello, I've been driving myself insane trying to figure out how to complete this function. I'm trying to sum up a total number of hours for a resource. For instance, a resource will choose a project they're working on from the drop down and input the hours spent on the project in a different column.

I'm trying to get a total count of hours for each project (drop-down) entered. So, in this resource's spreadsheet/timesheet, we have a total number of hours worked on each project based on the amount of hours they inputted into the "hours" column.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!