Hi, hope someone can help.
Returning a count of instances of "1" where the Role column value in Table1 is 3
Can someone please help explain why this doesn't work if C4 contains Table1 and D4 contains Skill1
My aim is to inject the table and column references from cell values in C4 and D4.
The INDIRECT syntax works with count but I cant get it to work with the condition of the other column (role) value.