Calculate cell reference

  • Thread starter Thread starter Jesse Wiggins
  • Start date Start date
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
 
Jesse,

You can use the INDIRECT function as you have described,
but you need to input a string so you'll have something like

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

Dan E
 
So close.

My ultimate goal is to have a graph query cells to find whether they meet a
certain criteria to determine the 'data range' in the graph. I cannot seem
to get the 'Source Data' window to let me use the INDIRECT function when
defining a 'Data range'. I get the 'Reference is not valid.' error.

My data range looks like this:
=INDIRECT(Data!$F$25)

Where F25 is a cell that calculates whether the values in a group of cells
is "<50".

The funny thing is that even though I get an invalid reference error, the
graph preview displays correctly! Very aggravating.

-Jesse
 
Back
Top