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 GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Answers

  • 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 GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • jelfner
    jelfner ✭✭✭

    Thank you so much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!