Thread: More help with 'INDIRECT'

Hi

Last week you kindly helped me with......

=COUNTIF(INDIRECT("'"&H2&"'!B3"),10)

count if the cell B3 on sheet as directed from whatever is in cell H2 = 10

What I've been trying to do ever since is to replace the B3 with another Cell reference e.g. if the value B3 is entered in cell G2 it would be as before, but if the value of cell G2 was changed to B4 it would look at that cell on the sheet as directed in cell H2. (hope that makes sense)

I've been trying to get it to work with another instance of INDIRECT without any luck.

Thanks in advance.