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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!