Advanced Lookup to count cells in a column that meet criteria

Hi all,

In the attached spreadsheet there are two tables - table 1(left table) and table 2 (right table)

Table 1 uses the following conditional formatting formula in column C: =AND(ISBLANK(C1),NOT(ISBLANK(D1))).

In table 2, I want to count the number of rows in table 1 that have been highlighted by the above conditional formatting formula - Hopefully this is made clear in the attachment but let me know if I can further explain.


Many, many thanks for helping to solve this!