Count cells containing text only, excluding text with digits

Options

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

  • sharkasits
    sharkasits ✭✭✭✭✭
    Options

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!