Formula for counting cells that have a letter or a number

TracyM

Hi,

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.

Thanks!!

Dale Murphy

@TracyM How about just adding the two results?

=COUNTIF(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6)

seems to work for me.

dm

TracyM

That worked!! I think I tried everything except +

thank you so much