Return a number count based on criteria within two separate columns

Options

I'm seeking a formula that will return a value if a certain criteria is met in one column and another criteria in another column.

For example, I'm trying to count how many items there are that have "Medium (within next FY to 3 yrs)" with a status of "Green". I'm trying to report this in Sheet Summary. Thank you!


Tags:

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 12/12/20 Answer ✓
    Options

    Hi @Shane Sorensen ,

    Try:

    =COUNIFS([Timeframe]:[Timeframe], "Medium (within next FY to 3 yrs)", [Status]:[Status], "Green")

    Standard COUNTIFS syntax should work for this.

    Good luck.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 12/12/20 Answer ✓
    Options

    Hi @Shane Sorensen ,

    Try:

    =COUNIFS([Timeframe]:[Timeframe], "Medium (within next FY to 3 yrs)", [Status]:[Status], "Green")

    Standard COUNTIFS syntax should work for this.

    Good luck.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Hi Shane, Glad it worked. Thanks for using the Community.

    Be Well,

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!