Indirect address inside "" Khoshravan 25.06.2006 13:07:01 =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

RE: Indirect address inside "" byundt 25.06.2006 15:46:02 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: [Quoted Text] > =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

RE: Indirect address inside "" Khoshravan 25.06.2006 23:31:01 Thanks. It was an interesting solution. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "byundt" wrote: [Quoted Text] > 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