Using COUNTIFS formula to count all starred items on multiple sheets

Options

I am running into issue using COUNTIFS formula. trying to count all starred items on multiple sheets and the formula i'm gives me UNPARSEABLE results: COUNTIFS({ABC Plan Range 1},1{DEF 1},1{GHI 1},1). Any ideas?.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!