=COUNT(CONCATENATE("'Sheet1'!",CONCATENATE("A",SUM(MATCH('Sheet2'!A1,'Sheet1'!$A:$A,0)-1))),CONCATENATE("'Sheet1'!",CONCATENATE("Z",SUM(MATCH('Sheet1'!A1,'Sheet1'!$A:$A,0)-1))))
The concatenates work to what I want, evaluating to COUNT(Sheet1!A(matched row):Sheet1!XYZ(matched row)) but the count always returns zero. Any ideas on why this might be?
Bookmarks