# SUMIF Formula ?

Options
✭✭✭

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:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

Thank you so much!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!