SUMIF Formula ?

jelfner

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!

AravindGP

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.

AravindGP

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.

jelfner

Thank you so much!