SUMIF Question

Options

Hello,

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 ✓
    Options

    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!

    Best,

    Heather

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!