Count cells containing text only, excluding text with digits
Salèha El D.
✭✭✭✭✭
Hi,
I need help with a function/formula:
I am looking at counting the number of crew (they are listed by first name) and at the same time exclude any cells with text & digits (names with quantity).
I hope this makes sense  I did some search and cannot find any formula that does the job.
Many thanks,
Thanks,
Salèha
Salèha El D.
Talks about #Smartsheet #productivity, #eventindustry, and #informationtechnology
➖Continuous improvement – for me, an ongoing desire to enhance processes, and increase productivity ➖
Tags:
Answers

@Salèha El D. Is the number always on the right?
If yes:
=COUNTIF(Names:Names, IFERROR(VALUE(RIGHT(@cell, 1)), "OK") = "OK")
If no:
=COUNTIF(Names:Names, NOT(OR(CONTAINS("0", @cell), CONTAINS("1", @cell), CONTAINS("2", @cell), CONTAINS("3", @cell), CONTAINS("4", @cell), CONTAINS("5", @cell), CONTAINS("6", @cell), CONTAINS("7", @cell), CONTAINS("8", @cell), CONTAINS("9", @cell))))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 216 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!