Computed Cell Reference in an Array Formula

  • Thread starter Thread starter Joe Blow
  • Start date Start date
J

Joe Blow

Hi,

I would like to use the last non-blank row as a reference in an array
formula.

For instance:

My last non-blank row is 46, I have a cell, x2 that computes the 46.
Now I would like to use it as an array reference.

In example:

{=sum(if($G$10:$G$200<=13,$D$10:$D200,0))}

In this case I would like to replace the 200 reference with the
computed value from x2.

Any ideas?

Thanks for helping,
Joe
 
You could use INDIRECT:

=SUM(IF(INDIRECT("$G$10:$G$"&X2)<=13,INDIRECT
("$D$10:$D"&X2,0))

Array-entered.

HTH
Jason
Atlanta, GA
 
Back
Top