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

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

AEC

Aug 11, 2023

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

---

View Post

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

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

AEC

Aug 11, 2023

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

---

View Post

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