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

Hello.

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: https://app.smartsheet.com/sheets/VjPxRQ8VmfG25xV5c8524q3R9VxgcXGjR3Q7qRF1?view=grid

Thank you for advance for the assistance.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!