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
 10.6K Get Help
 63 Global Discussions
 67 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!