Incorrect Argument

Options

Any idea of what I'm doing wrong with this formula?

=COUNTIFS({Airport}, "IAH", {Q2}, "Yes") / COUNTIFS({Airport}, "IAH", {Q2})

Best Answer

  • heyjay
    heyjay ✭✭✭✭✭
    Answer ✓
    Options

    Missing criteria for your second COUNTIFS Q2.

    =COUNTIFS({Airport}, "IAH", {Q2}, "Yes") / 
    COUNTIFS({Airport}, "IAH", {Q2},"SECOND CRITERION HERE")
    


    ...

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!