Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

SUMIFS formula


I'm trying to create a formula that adds my second and third column if the fourth column says "LOST" , I want that same formula to subtract the second column from the first column if the fourth column says "KEPT".

-My column titles are:

Column1: total budget

Column2: money allocated

Column3: tentative remaining

Column4: account status

Column5: amount remaining

I've been fooling around with different formulas for a while and I can't get anything to work. any suggestions?


2017-06-01 13_34_04-Greenshot.jpg


  • Ian

    =IF([Account Status]1 = "LOST", [Money Allocated]1 + [Tentative Remaining]1, IF([Account Status]1 = "KEPT", [Money Allocated]1 - [Total Budget]1, 0))

    This formula is only looking for LOST or KEPT, if those are not in [Account Status] it will return 0

This discussion has been closed.