Hi,

Example Background info:
Sheet2 Column D contains XXX records

Problem:
The following equation works:
=COUNTA(Sheet2!D:D)

The following equation doesn't work:
=COUNTA(CONCATENATE("Sheet2!",D1,":",D1))

How do I make the second scenario work?

I would like to know because I am ultimately trying to make this work:
=COUNTA(CONCATENATE(VLOOKUP(MATCH(C1,Sheet2!$1:$1,0),$A$1:$B$1060,2),":",VLOOKUP(MATCH(C1,Sheet2!$1:$1,0),$A$1:$B$1060,2)))