SUMIF Question



I am trying to sum a column in my smartsheet that has numbers, but only want to sum those with a status of "Business as Usual"....seems pretty straight forward, but I'm hitting walls and have even reached out to someone who has far more advanced skills than I do. Here's the current formula I am using: =SUMIF([# of Records/Transactions]:[# of Records/Transactions], >=1, Status:Status, "Business as Usual") - FYI have also tried the same with SUMIFS. Help?

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi Dee Dee,

    Try this: =SUMIF(Status:Status, "Business as Usual", [# of Records/Transactions]:[# of Records/Transactions])

    The funny thing about switching from SUMIFS to SUMIF is that the column that you want to sum gets moved from the beginning of the string to the end in a SUMIF.

    Hope this helps!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!