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!