HELP. How to find matching dates in 2 different columns, then count multiple texts within another column totaling in another column

[jqadri]

Long story short for you all :

There has been an update in my system at work and the beautiful data tracker that I was given to take over is not able to accurately display information anymore due to word modifications.

I'm a newbie to excel too.

Logic:

If column J (full of dates) matches specific date in a cell that is in column W) then find 5 different words from column C and put the total in column AA. Tried:=COUNTIFS(J:J,W536,C:C,"word1")+COUNTIFS(J:J,W536,C:C,"word2")+COUNTIFS(J:J,W536,C:C,"word3")+COUNTIFS(J:J,W536,C:C,"word4")+COUNTIFS(J:J,W536,C:C,"x word5") =INDEX(J:J,MATCH(W535,C:C,"word1","word2" etc = <tbody> </tbody>

<tbody>
</tbody>

 

[Weazel]

If I'm understanding correctly maybe something like....

=SUM(COUNTIFS(J2:J5000,W535,C2:C5000,{"word1","word2","word3","word4","word5"}))

 

[jqadri]

That is way less complicated, it worked. THANK YOU SO MUCH!