Formula for counting cells that have a letter or a number

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!!

Find more posts tagged with

Accepted answers

All comments

Dale Murphy

@TracyM How about just adding the two results?

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

seems to work for me.

TracyM

That worked!! I think I tried everything except +

thank you so much

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.