COUNTIFS with 3 criteria


I was wondering someone could help me figure out what is wrong with my formula. I'm trying to reference another sheet and produce a countifs figure based on three different criteria:

Range 1: Type = Project

Range 2: Category = Digital

Range 3: RAG = Red

This is my formula:

=COUNTIFS({Children's Transformation Range 1}, "Project") + COUNTIFS({Children's Transformation Range 2}, (CONTAINS("Digital", @cell))) + COUNTIFS([{Children's Transformation Range 3}, "Red")))

The strange thing is it works fine with the first two criteria but is unparseable when I add the third.

Any help would be greatly appreciated!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!