# Counting the Number of times certain text appears in a Column

✭✭✭✭

Hello!

I need assistance to create Sheet Summary items to count all of the instances where certain Unit Code(s) is listed in a column. Some codes can be combined with others (C1 + C2) vs by themselves (C2).

So, to start I need to count the number of times Unit Code "C2" is listed/mentioned. Eventually I will also need to capture the times other instances/combinations are listed as well. I have a few Sheet Summary items created to represent these options.

I have searched and tried different formulas, but nothing seems to get to the result I'm looking for.

Test sheet is here to show example: https://app.smartsheet.com/b/publish?EQBCT=2a8f00cc49eb4021916f06af91e28095

Thank you in advance for your assistance.

• ✭✭✭✭

@Andrée Starå - that worked, thank you! I swear that is what I was trying to do as well, but couldn't get it to work before.

Thanks again for the assistance as I continue to learn more and more about the formulas within Smarthseet!

• ✭✭✭✭✭✭

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭
edited 10/13/20

@Andrée Starå ... another variation on this same theme.

What about counting different info in the same column ... example, I need to count all instances of "C1" and all instances of "C2" in a column ... I tried the formula below but it is not returning the correct numbers:

=COUNTIFS([UNIT CODE]:[UNIT CODE], CONTAINS("C1", @cell), [UNIT CODE]:[UNIT CODE], CONTAINS("C2", @cell))

Thank you!

• ✭✭✭✭✭✭

I hope you're well and safe!

Excuse the late response.

I assume that you've solved it, or do you still need help?

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!