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!



Tags:

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.

    Thanks,

    Aravind

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!