Check if word exists and count how many times, help

[execine]

Hello,

i need to do one project for a university, and i can't get the formula right... hope somebody can help me out, would appreciate that alot!

situation is this. I have two text articles and have all their words put to column a with a count of how many times each word appears in all article (see attachmen), columns A and B.

Then respectively in columns GH and IJ there are words from each article and number, how many times each word appears in article.

I need to come up with a formula, to get numbers in indicated in red (in the attachment) which checks if the word on column A exists in Article 1 and if yes, how many times.

Appreciate your help!!

[zbor]

Here, check this with SUMIF formula:

[execine]

works!! thank you a million times!

will visit this forum more frequently for excel related issues,
thank you once again!