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
Check out the Formula Handbook template!