Nested Count and indirect functions

Hello,

Is there an obvious why the following formula does not work:

=COUNT(INDIRECT("AA"&AG2)) but this one does:=COUNT(INDIRECT(AE9)). Thank you.

jrbluebox

Hi
It looks like you are trying to Concatenate column AA and cell AG2 which is why it wont work.
Tony

Hi Tony,

I am trying to build a cell address; AG2 contains a number. For example =INDIRECT("AA"&AG2) works fine - the ouput is a range - but somehow the count function does not recognise it.

jrbluebox

Is there a reason why the formula evaluates $AA$10 rather then Indirect($AA$10). Because $AA$10 is the output of ("$AA$"&10), but not of Indirect($AA$10). For the sake of the argument $AA$10 contains a range, for example B10:B1234. Thanks.

Sorted! Thanks, Tony.