Sumif and Contains??

I have one column set to multi-select with months (August 2020, Sept 2020 ect). I have another column with capacity numbers. I want to build a formula that adds all the capacities together by month, so it only pulls in the capacity if for that row if say Sept 2020 is selected in the multiselect in the same row. I want to do the same formula for each month, so the capacity will be counted in the total for each month that it applies to (hopefully I am making this make some sort of sense).

I assume it might be a sumif with a contains added in, but everything I have tried hasn't worked.

Any help would be amazing!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!