Count the total # cells with a specific word in a filtered column?

I have a COUNTIF but it is retruning a value that represents the entire sheet and not just the number of cells on the filtered sheet. Is it possible to restrict the formula to the filtered sheet only?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!