SUMIFS Formula
Hi,
I am trying to sum the numbers in the first column where the states are CA, CO, DC and IA. Could you please help. I a still learning formulas in Smartsheet. Thanks!
Answers
-
=sumif(total:total,or(@cell = "CA",@cell = "CO",@cell = "DC",@cell = "IA"),b:b)
* I can't read the second column name where your values are so you need to replace each b in b:b with your column name.
-
The above is the traditional smartsheet way to do it, but there are a couple other more unconventional ways to make this formula shorter.
=sumif(total:total,find(@cell,"CA,CO,DC,IA")>0,b:b)
is a fun example. I doubt this one is any faster, but it might be easier to add/remove items, and could shorten a future potentially very long formula.
-
Thank you so much! I used the shorter version and it worked like a charm. :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!