How would you combine the CONTAINS or HAS function with a SUMIFS formula?

I am trying to create a formula which sums the total number of machines we have delivered for certain projects, but in the "Project Name" column, we have different stages of the same project which I want to combine. E.g.

Project Pearl 1.1 - 5 machines delivered

Project Pearl 1.2 - 5 machines delivered

Project 1.3 - 5 machines delivered


So my CONTAINS/HAS formula would search for "Pearl" and return 15, but I keep getting INVALID OPERATION errors when I try the following:

=SUMIFS({Projects Sheet Range 1}, {Project Sheet Range 3}, "Hardware Delivery", HAS{Project Sheet Range 9}, “Pearl”)

Range 1 - Quantity field

Range 3 - Activity field

Range 9 - Project Name field

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!