Counting Multiple Symbols

Options

Hello!

I have tried COUNTIF and COUNTIFS trying to get the count of "Yellow" and "Red" symbols. I'm using Green, Yellow, and Red.

Is there a formula that will populate the total of the Yellow and Red within a single column?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!