Indirect address inside ""

K

Khoshravan

=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.
 
B

byundt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Using SUM(INDIRECT()) 2
using row number or column letters in formula 6
problem with formula 6
INDIRECT function to reference a named range 2
Chart growth by quarter with two date fields 3
Indirect reference causes statistical function to throw up a #NUM! 10
Using the INDIRECT function across multiple worksheets 0

Top