Having a problem with Countif formula not letting me count if it needs two criterias

Options
Chad Rasmussen
edited 06/15/22 in Formulas and Functions

Ok I am stumped on this one. I have read through some articles and thought I had an answer but nope.

I am trying to do a countif formula for a sheet summary field. I want a count if the cell in Phase 1 Column says "Kong" and if the Team Completion % is 100%

Here is the Formula I am using

=COUNTIF([Phase 1 QE Work Package]:[Phase 1 QE Work Package], ="Kong") + =COUNTIF([Team Completion %]:[Team Completion %], =1)

Of course they work on their own. But when I try that formula it gives me an invalid operations error.

Best Answers

  • Stacey Carrasco
    Stacey Carrasco ✭✭✭✭✭✭
    edited 06/14/22 Answer ✓
    Options

    try adding the S at the end of COUNTIF and then you can add both your variables and remove the + sign

    try =COUNTIFS([Phase 1 QE Work Package]:[Phase 1 QE Work Package], "Kong", [Team Completion %]:[Team Completion %], "100%")

    although the 100% value may be .01 not sure try it out and see what you get

    Senior Program Coordinator

    De Anza College

  • Chad Rasmussen
    Answer ✓
    Options

    @Stacey Carrasco

    Thank you for your help. I forget the COUNTIFS formula. Your formula was great the only thing I had to change was the end where is was the "100" had to be "1"

Answers

  • Stacey Carrasco
    Stacey Carrasco ✭✭✭✭✭✭
    edited 06/14/22 Answer ✓
    Options

    try adding the S at the end of COUNTIF and then you can add both your variables and remove the + sign

    try =COUNTIFS([Phase 1 QE Work Package]:[Phase 1 QE Work Package], "Kong", [Team Completion %]:[Team Completion %], "100%")

    although the 100% value may be .01 not sure try it out and see what you get

    Senior Program Coordinator

    De Anza College

  • Chad Rasmussen
    Answer ✓
    Options

    @Stacey Carrasco

    Thank you for your help. I forget the COUNTIFS formula. Your formula was great the only thing I had to change was the end where is was the "100" had to be "1"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!