Sum if formula based on condition in another cell
Looking for help on a formula! I want to sum the Forecast Amount values where the Sales Stage is equal to the value in the Status column. So for example, Status11 is equal to 2  Qualification. I want the amount in Forcast Amount10 to be the sum of all the instances in the data below where the Sales Stage is equal to 2  Qualification. I've attached a screenshot with sample data. Thanks!!!!
Comments

Hi Cyndi,
If I understand you correctly the below formula should work.
Try this.
Place the formula below in the Forecast Amount 10 cell.
=SUMIF(CHILDREN([Sales Stage]10); "2  Qualification"; CHILDREN([Forecast Amount]10))
The same version but with the below changes for your and others convenience.
=SUMIF(CHILDREN([Sales Stage]10), "2  Qualification", CHILDREN([Forecast Amount]10))
Depending on your country you’ll need to exchange the comma to a period and the semicolon to a comma.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!