SUMIF Question

Dee Dee Moradiellos (US - IFS)

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?

Heather Duff

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

Heather Duff

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

Dee Dee Moradiellos (US - IFS)

Thank you Heather! That did it!

Heather Duff

Fantastic! So glad it worked.