SUMIF Formula ?

Hello! I am trying to make the following formula. If "Actuals (Cash-In-Hand)" is greater than "Budget" list the overperformance difference in "Over-Performance". If there is an underperformance it should stay $0.00. In this case the overperformance is $1,185,852.00. Thank you for your help!


Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    Hi @jelfner

    You can write a the following formula in the row against January for Over-Performance

    =IF([January]7 > [January]5, [January]7 - [January]5, 0).

    7 and 5 here are supposed to be the row numbers of where Actuals (Cash-In-Hand) and Budget.



    Reach out for any help on licenses, configuration, or training


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!