Good day!

Okay, so my last thread didn't seem realistic. So I decided to tackle on my problems 1 at a time and see if I can build on it from here.

We know how INDEX/MATCH works, and it's very nice. I attached a COUNTIF to it to count how many times the index finds itself on another table; if it doesn't find itself, then it goes blank. However, this time I need to count how many times it finds a certain string condition in the other table.

Am I making sense?

Here is a sample file which I hope will help:

sampleexcelhelp.xlsx

The columns that need to be filled are shaded in dark pink. Thank you!