Countif containing a specific word in another sheet
Hello,
I am trying to make a countif function to extract the number of times a specific word is presented in another sheet. Some other criteria (Like the year has to be 2023) exist. So far, what I have is this:
=Countif ({sheet range}, HAS(@cell, [the word I'm trying to find]), [Year range in sheet range], "2023")
I can't seem to find the issue but it does not produce what I was hoping for. I tried contain and find function instead of has, but that doesn't seem to work either. Any suggestions help! Thank you!
Answers
-
Hello @Adam1234,
Perhaps something like this?
=IF(CONTAINS(@cell, ["word"]),COUNTIF({sheet range},[Year range in sheet range], "2023","")
-
Hi @Mr. Chris ,
Thanks for your response, but it does not quite work. I am trying to pull from one column only from a separate to extract a specific word. For example, I am trying to see how many times "Green" is mentioned in the Colors column in my separate sheet. There is also a year column to help identify the year. If more information is needed, please let me know. I know I am close but I am not able to get there just yet!
-
You will need a COUNTIFS function (with the "S" on the end) to be able to include multiple range/criteria sets.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!