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

AEC

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.!

SteyJ

https://community.smartsheet.com/discussion/108878/count-frequency-of-a-specific-word-after-a-specific-date-on-reference-sheet

Hello @AEC,

This should do the trick

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

Hope this helps

AEC

Thank you!!! This worked like a charm. 😉

SteyJ

https://community.smartsheet.com/discussion/108878/count-frequency-of-a-specific-word-after-a-specific-date-on-reference-sheet

Hello @AEC,

This should do the trick

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

Hope this helps

AEC

Thank you!!! This worked like a charm. 😉