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:[TABLE="width: 414"]
<tbody>[TR]
[TD="width: 414"]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")

[TABLE="width: 414"]
<tbody>[TR]
[TD="width: 414"]=INDEX(J:J,MATCH(W535,C:C,"word1","word2" etc

=

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

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