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
-
Ok. Try something like this...
=SUMIFS([Capacity Column]:[Capacity Column], [Recommended Dates]:[Recommended Dates], CONTAINS("October 2020", @cell))
Answers
-
Are you able to provide a screenshot with sensitive/confidential information removed, blocked, and/or replaced with "dummy data" as needed?
-
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.
-
Ok. Try something like this...
=SUMIFS([Capacity Column]:[Capacity Column], [Recommended Dates]:[Recommended Dates], CONTAINS("October 2020", @cell))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!