SumIf and Contains referencing another sheet

Alisa Buck

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

Antonio Figueroa

=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