Indirect address inside ""

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khoshravan - 25 Jun 2006 14:07 GMT

=COUNTIF(F$2:F$1561;">0.9") J4=0.9

I want to drag above command, downward. Value of 0.9 is stored in J4.
How can I produce J4 with formula so that it repeats while dragging.
I face this problem a lot. I think by combination of Indirect and Row it is
possible to solve. I tried some combination but they didn't work.

Signature

Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

Reply to this Message

byundt - 25 Jun 2006 16:46 GMT

Try putting an absolute reference to cell J4 inside the COUNTIF:
=COUNTIF(F$2:F$1561;">" & $J4)

As you copy this formula across, it will always reference the value in cell
J4.

Signature

Brad

> =COUNTIF(F$2:F$1561;">0.9") J4=0.9
>
> I want to drag above command, downward. Value of 0.9 is stored in J4.
> How can I produce J4 with formula so that it repeats while dragging.
> I face this problem a lot. I think by combination of Indirect and Row it is
> possible to solve. I tried some combination but they didn't work.

Reply to this Message

Khoshravan - 26 Jun 2006 00:31 GMT

Thanks. It was an interesting solution.

Signature

Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

> Try putting an absolute reference to cell J4 inside the COUNTIF:
> =COUNTIF(F$2:F$1561;">" & $J4)
[quoted text clipped - 8 lines]
> > I face this problem a lot. I think by combination of Indirect and Row it is
> > possible to solve. I tried some combination but they didn't work.

Reply to this Message