Calculate cell reference

J

Jesse Wiggins

I need to calculate a cell reference with a formula.

For instance:

Instead of using
=D6
I need to have excel calculate the '6' portion -- like this
=D&(COUNTIF(D6:D32,"<50"))
so it will use the result of the function to determine the cell number.

I have not been able to successfully reference a cell using a formula. Is
this even possible?

Thanks,
Jesse
 
N

Nimish

Hi Jesse,

Try to use INDIRECT function as follows. This function converts string
to cell reference

This function is relatively less explored and least understood. Once
concept is clear it opens unlimited capabilities in spread sheet
calculations.

=INDIRECT("D"&(COUNTIF(D6:D32,"<50")))

Regards,
Nimish Parikh
 
Top