SUMIFS OR question
I have this formula that works with the "CONTAINS" function, but I now want it to equal that number instead of contains (as the contains doesn't work if it equals oddly enough).
=SUMIFS({TOTAL COST - Costing Sheet}, {CODE - Costing Sheet}, OR(CONTAINS("300", @cell), CONTAINS("301", @cell), CONTAINS("302", @cell), CONTAINS("802", @cell), CONTAINS("855", @cell), CONTAINS("303", @cell)), {WALL ID - Costing Sheet}, [Wall ID]@row)
I tried having @cell=the number, but that doesn't work. (*I removed a bunch of the numbers until I can get the formula to work!)
=SUMIFS({TOTAL COST - Costing Sheet}, {CODE - Costing Sheet}, OR(@cell = "300", @cell = "301"), {WALL ID - Costing Sheet}, [Wall ID]@row)
Any thoughts other than adding all my sumifs together?
Thanks!
Best Answer
-
Disregard - after more searching I found that substituting HAS for CONTAINS in my first formula works for exact values. (I still don't understand why the second one doesn't work as I found that as a solution for other posts, so if you come across this post and know the reason please feel free to comment!)
Answers
-
Disregard - after more searching I found that substituting HAS for CONTAINS in my first formula works for exact values. (I still don't understand why the second one doesn't work as I found that as a solution for other posts, so if you come across this post and know the reason please feel free to comment!)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!