Countifs and Contains formula combined calculate a 0

Hello, I'm trying to count how many times the word"Blended" shows up in the Class column when the stage column is "proposal". I'm using the following formulas which always renders a 0. Can you please help me correct my formula? Thank you!

=COUNTIFS(Stage:Stage, "Proposal", [Class]:[Class], CONTAINS("Blended", [Class]:[Class]))

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try replacing the range in the CONTAINS function with @cell.

    =COUNTIFS(Stage:Stage, "Proposal", [Class]:[Class], CONTAINS("Blended", @cell))

    This tells the formula to run the CONTAINS function on a cell by cell basis in the previously established range.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!