Hi,
I have the following formula
=COUNTA('4-6'!A:A)-1
where the worksheet name is '4-6'
However I want to use the INDIRECT function as I need to repeat this for multiple sheets and they all have different names based on a date. The date is in cell B2... and I thought the following would work:
=COUNTA(INDIRECT("'"&DAY(B2)&"-"&MONTH(B2)&"'!A:A)-1"))
However this brings the wrong value.
I have also tried:
=COUNTA(INDIRECT("'"&DAY(B2)&"-"&MONTH(B2)&"'!A:A)")-1)
This doesn't give the correct answer either.
Any idea of where I am going wrong?
Thanks
I have the following formula
=COUNTA('4-6'!A:A)-1
where the worksheet name is '4-6'
However I want to use the INDIRECT function as I need to repeat this for multiple sheets and they all have different names based on a date. The date is in cell B2... and I thought the following would work:
=COUNTA(INDIRECT("'"&DAY(B2)&"-"&MONTH(B2)&"'!A:A)-1"))
However this brings the wrong value.
I have also tried:
=COUNTA(INDIRECT("'"&DAY(B2)&"-"&MONTH(B2)&"'!A:A)")-1)
This doesn't give the correct answer either.
Any idea of where I am going wrong?
Thanks