Formula Formatting issue, not sure how to write it

[niktodorov1]

I have the following function:

=ROWS(DX:D99)

And I want the X in "DX" to be define by the contents of cell "F10", which contains 10.

What would be the correct formatting for accomplishing this?

Thank You!

[protonLeah]

one way:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

[jtakw]

Hi,

Another way:

=ROWS(INDIRECT("D"&F10&":"&"D99"))