Sum if formula based on condition in another cell

Options
cyndi2403
cyndi2403 ✭✭✭
edited 12/09/19 in Formulas and Functions

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

Capture33.PNG

Tags:

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    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!