Indirect address inside ""
 

=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.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

Indirect address inside ""
 

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.
--
Brad


"Khoshravan" wrote:

=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.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

Indirect address inside ""
 

Thanks. It was an interesting solution.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"byundt" wrote:

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.
--
Brad


"Khoshravan" wrote:

=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.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan