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

Nancy Heater

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.

David Tutwiler

I think this will work:

=SUMIF([Unit Code(s)]:[Unit Code(s)], CONTAINS("C2", @cell), Qty:Qty)

David Tutwiler

I think this will work:

=SUMIF([Unit Code(s)]:[Unit Code(s)], CONTAINS("C2", @cell), Qty:Qty)

Nancy Heater

It did!! Thank you so much @David Tutwiler !

David Tutwiler

Awesome! Great to hear.