=COUNTIF({Survey Intake }, <5>2

Hey Guys i am trying to do a formaula that will count figures in a column but need to count all numbers between 5 and 2

so all numbers 3 and 4

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Sue van Niekerk 

    Hope you are fine, please try the following formula:

    =COUNTIFS({Survey Intake }, AND(@cell < 5, @cell > 2))

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!