Count frequency of a specific word after a specific date on reference sheet

I am trying to count the occurrence of specific words within another sheet that were made after a specific date. For example, where the word I want to count is Range 1 ("Word") and the date is found in Range 2).

=COUNTIFS({Intake Sheet Range 1}, "WORD" {Intake Sheet Range 2}, ">" & DATE(2023, 5, 1)

Thanks in advance for any recommendations.!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!