Modify a Formula

C

carl

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

T. Valko

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.
 

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

Modify Formula 2
Using IF, AND and OR functions together 2
Modify a Formula 4
HELP: IF Statement between Dates for Reverse Index failing 0
Return blank cell if data cell is blank 4
Adding cells but leaving blank if not populated 2
@IF Formula 3
Isblank error 3

Top