Using COUNTIFS with AND in Summary Sheet

edited 03/05/24 in Formulas and Functions

Current Formula is for # Enrolled

=COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course")

I need a formula for Enrolled AND # Late Status Red X


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @IES,

    please try the following formula:

    =COUNTIFS(Enrolled:Enrolled, 1, [Status]:[Status],"No")

    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"

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭

    Hi IES,

    As you want one more condition in the formula, you can provide another range and criterion in the formula of countifs.

    Please refer following link-

    If you are still facing issues, please share some screenshots for the context where you are trying to apply the formula with the fields required in it.

    Thank you

    Anjanesh Vaidya


    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!