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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!