Hi.

I use this formula:

=COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40)

I would like to modify it so that the value I put in Cell A1 (eg 100) will
change the formula to this:

=COUNTIF(I5:I100;TRUE)/COUNTA(I5:I100)

Thank you in advance.

Check the INDIRECT() function in HELP

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"carl" wrote in message
...
Hi.

I use this formula:

=COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40)

I would like to modify it so that the value I put in Cell A1 (eg 100) will
change the formula to this:

=COUNTIF(I5:I100;TRUE)/COUNTA(I5:I100)

Thank you in advance.

Try this...

=COUNTIF(I5:INDEX(I:I,A1),TRUE)/COUNTA(I5:INDEX(I:I,A1))

Note that if A1 is an empty cell the formula will calculate the entire
column I.

--
Biff
Microsoft Excel MVP


"carl" wrote in message
...
Hi.

I use this formula:

=COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40)

I would like to modify it so that the value I put in Cell A1 (eg 100) will
change the formula to this:

=COUNTIF(I5:I100;TRUE)/COUNTA(I5:I100)

Thank you in advance.