Formula for counting cells that have a letter or a number



I have a smartsheet that lists students and what grade they are in (K, 1, 2, 3, etc.). I'm trying to do a sheet summary that will count students who are in grades K-5. How can I write a formula that will count the numbered cells but also the cells with the K in it.

I can get it to either count the cells with K or count the cells with 1, 2, 3, 4, or 5 - but I can't come up with a formual to do all.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!