Count data in a column based on "contains" criteria in another



For my Summary report, I'm trying to pull a total sum from the "Qty" column for any rows that contains "C2" in the "Unit Code(s)" column.

Example sheet:

Thank you for advance for the assistance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!