Countifs and Contains formula combined calculate a 0

Theresa Bruns

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]))

Paul Newcome

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.

Paul Newcome

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.

Theresa Bruns

Thank you! I always get the answers on this forum. I really appreciate your help!

Paul Newcome

Happy to help. 👍️