Sumif and Contains??

Ashley Oliver

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!

Paul Newcome

Ok. Try something like this...

=SUMIFS([Capacity Column]:[Capacity Column], [Recommended Dates]:[Recommended Dates], CONTAINS("October 2020", @cell))

Paul Newcome

Are you able to provide a screenshot with sensitive/confidential information removed, blocked, and/or replaced with "dummy data" as needed?

Ashley Oliver

Sure. So below I have the two columns circled I am talking about. I want to add the capacity total for the end column by month, so if we are referencing October 2020 it would only pull capacities into the total where the corresponding cell had October as an option.

Paul Newcome

Ok. Try something like this...

=SUMIFS([Capacity Column]:[Capacity Column], [Recommended Dates]:[Recommended Dates], CONTAINS("October 2020", @cell))