Countif containing a specific word in another sheet

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!