Problem using ADDRESS function to specify a cell range in another sheet

[codataguy]

Hello,
I am trying to use the ADDRESS function to specify a range in another sheet, and it's not working.
Here is the formula with direct cell range reference that works:
=COUNTA(data!$A$5:data!$A$2633)
This generates the correct count of 2629

Here is the formula with the ADDRESS functions to build the range:
=COUNTA(ADDRESS(5,1,1,,"data")&":"&ADDRESS(2633,1,1,,"data"))
This generates the incorrect count of 1

I also tried using the INDIRECT function to help build the range:
=COUNTA(INDIRECT(J2))
where J2 has the formula =ADDRESS(5,1,1,,"data")&":"&ADDRESS(2633,1,1,,"data") and generates the value data!$A$5:data!$A$2633
This generates the incorrect count of 1

Any thoughts?
Thanks in advance!

 

[Tetra201]

Try using the following formula in cell J2:

=ADDRESS(5,1,1,,"data")&":"&ADDRESS(2633,1,1)

 

[codataguy]

Hi @Tetra201,
that did it - thank you!

 

[Tetra201]

Glad to have helped.