How can I create a sheet that counts occurrences of a word in multiple sheets?

moorejr

I would like to create a sheet that tallies up all the instances of certain words, such as 'retain', 'rotate', 'textile', etc., from multiple sheets.

So it would look like:

Retain - 30

Rotate - 50

Textile - 20

etc.

Is this possible?

Eric Law

Hello @mooree1. Are the sheets the same? Are there multiple instances of the word in a cell? Are there multiple columns that you are checking? The most basic of this would be =COUNTIF([column to check]:[column to check], CONTAINS("word", @cell))

moorejr

Yes, all the sheets are the same, with the same column names. There's only one instance of the word in a cell and I'm only checking one column.

Andrée Starå

https://community.smartsheet.com/discussion/109679/how-can-i-create-a-sheet-that-counts-occurrences-of-a-word-in-multiple-sheets

Hi,

I hope you're well and safe!

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!