Countifs and referencing another sheet


I'm attempting to use a countif using two criteria referencing another sheet. I want to see only the projects in "Entrance/Intake" that are in "House" SHRS. I'm getting the #UNPARSEABLE error.

My Countif formula for only Entrance/Intake works perfectly. I need to slice this data by each "house" (VP) and I cannot figure out what I am doing wrong.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!