Excel Table - refer to a particular row.xlsx

In the file attached, in sheet 1, there is a table (Table 1) with a column of names.

In sheet 2, there is also a table (Table 2) with a column of same names.
I would like to in sheet 1 have a column (below) to count a particular row if there is any blank cell in that row. For example, the person "f" in Table 2 has two blank cells and in Table 1, the column "Count" for person "f" should be 2 (actually is now).

But when I have a different sort in Table 1, the Countif formula in Table 1 does not follow the person "f". As a result, the Count result for each person in Table 1 is wrong.

Please see the attached file for the whole picture.
Any help is appreciated.