Sum If Formula using Column with Multi select drop down

Amanda MedinaIW

Hello,

I am looking for the formula to sum a column (Work Stream) with specific text. The column is multiple select drop down. The drop down options are Available, Unavailable, Assigned and R&R. I need to sum all the rows that contain the drop down option "Available", even if they may contain other drop down options.

I have tried the below formula, and several others with no luck

=SUMIF([Work Stream]:[Work Stream], "Assigned")

Thank you!

Kerry St. Thomas

SUM is a mathematical function. You'd use it to calculate, for example, total sales dollars for things only in "East" geographic region. So numbers only. It doesn't work on text at all - so that could be one issue. As such, I'll answer as if your goal is to try to count how many rows have "Available" in the Work Stream column. If you are indeed adding numbers from a separate column, you can tweak the solution as needed. :)

=COUNTIF([Work Stream]:[Work Stream],CONTAINS("Available",@cell))

Good luck!