SUMIFS Formula

Irina Iatco
Irina Iatco ✭✭
in Formulas and Functions

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!


sumifs help.png


· Share on FacebookShare on Twitter

Answers

  • L_123
    L_123 ✭✭✭✭✭✭
    edited 08/07/20

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

    · Share on FacebookShare on Twitter
  • L_123
    L_123 ✭✭✭✭✭✭

    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.

    · Share on FacebookShare on Twitter
  • Irina Iatco
    Irina Iatco ✭✭

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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!