Count when 2 Conditions are met

Options
JamesS
JamesS ✭✭
in Formulas and Functions

I have a field called Status & a field call Health (using RYG symbols)

This =COUNTIF(Health:Health,"Green") counts the symbols correctly.

But I am trying to count Status "Open" that have a Health "Green".

So I tried using COUNTIFS…

=COUNTIFS([Health:Health],"Green",[Status:Status],”Open”)

Gives #UNPARSEABLE 😕 Can anyone help?

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Leroy Noriega
    Leroy Noriega Community Champion
    Answer ✓

    Try:

    =COUNTIFS(Health:Health, "Green", Status:Status, "Open")

    Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant

    Core App, Project Management, System Administrator and Control Center Blueprint Builder Certified🏅

    E: leroy.noriega@yahoo.com | Linkedin Profile

    · Share on FacebookShare on Twitter

Answers

  • Leroy Noriega
    Leroy Noriega Community Champion
    Answer ✓

    Try:

    =COUNTIFS(Health:Health, "Green", Status:Status, "Open")

    Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant

    Core App, Project Management, System Administrator and Control Center Blueprint Builder Certified🏅

    E: leroy.noriega@yahoo.com | Linkedin Profile

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!