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