SUMIF Formula ?
Hello! I am trying to make the following formula. If "Actuals (CashInHand)" is greater than "Budget" list the overperformance difference in "OverPerformance". 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

Hi @jelfner
You can write a the following formula in the row against January for OverPerformance
=IF([January]7 > [January]5, [January]7  [January]5, 0).
7 and 5 here are supposed to be the row numbers of where Actuals (CashInHand) and Budget.
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers

Hi @jelfner
You can write a the following formula in the row against January for OverPerformance
=IF([January]7 > [January]5, [January]7  [January]5, 0).
7 and 5 here are supposed to be the row numbers of where Actuals (CashInHand) and Budget.
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

Thank you so much!
Help Article Resources
Categories
Check out the Formula Handbook template!