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]))
Help Article Resources
Check out the Formula Handbook template!