# SUMIFS Formula

Options

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!

• ✭✭✭✭✭✭
edited 08/07/20
Options

=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.

• ✭✭✭✭✭✭
Options

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.

• Options

Thank you so much! I used the shorter version and it worked like a charm. :)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!