# Sum if formula based on condition in another cell

Options
✭✭✭
edited 12/09/19

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!!!!

Tags:

• ✭✭✭✭✭✭
edited 02/18/19
Options

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 semi-colon 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!