Without having gone deeply into your situation I think you need
something like:

=COUNT(INDIRECT(CONCATENATE("your formula")))

"your formula" is without the COUNT argument you're currently trying

You're currently putting the COUNT inside the INDIRECT, it needs to be
the other way around

so something like:
=COUNT(INDIRECT(CONCATENATE(A1,"!",A3,":",A3)))
where A1 contains your sheet name and A3 contains your refcol letter


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=515892