SumIf and Contains referencing another sheet
Hi All,
I have a sheet with a column of project codes and rows of individual's hours for each project. I want to build summary information on another sheet. So I want Smartsheet to sum the number of hours where the project code contains a unique set of 4 characters. I've gone through several of the community questions but can't get it to work correctly. Some questions:
1  What formula is recommended?  SumIf or SumIfs?
2  For the range, can I select the column heading or do I have to pick the range of rows?
3  For the contains, what is the proper sequence of "Contains", "@cell", and the 4characters I want included?
Thanks!
Alisa
Best Answer

=SUMIF(Range, Criterion, Sum_Range)
Range  is the list of Project Codes
Criterion  Is the Project Code you are looking to Sum
Sum  Range is the Hours column you are looking sum
Answers

=SUMIF(Range, Criterion, Sum_Range)
Range  is the list of Project Codes
Criterion  Is the Project Code you are looking to Sum
Sum  Range is the Hours column you are looking sum
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!