Sum rows if shared value in another column?
Hi,
I'm trying to summarize hours worked on each project for each month. My list of projects changes regularly with some coming in and some going out. Data is collected weekly so there will be multiple entries for each project. My thought was to SumIF the project identifier matches. I'm new to Smartsheet and have searched the community and haven't found a solution.
Thank you for any help you can offer!
Comments
-
Hi Amy,
yes, the SUMIF formula is the way to go.
Based on your example an simple example would be:
=SUMIF([Primary Column]:[Primary Column], "Pen", hours:hours)
If you require more conditions to be met, you have to use the SUMIFS formula. Be aware though, that in SUMIFS, the column to be counted has to be named first. Example:
=SUMIFS(hours:hours, [Primary Column]:[Primary Column], "Pen")
Smartsheet provides a great formula overview with live examples as a sheet in the provided templates. Search for "Smartsheet formula examples".
Greetings
Stefan
Projektmanagement Professional in Frankfurt am Main, Germany
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 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!