C
carl
I use this formula:
=COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40)
I would like to change the formula so that it will use the value in cell A1
(eg 200) like this:
=COUNTIF(I5:I200;TRUE)/COUNTA(I5:I200)
Thank you in advance.
=COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40)
I would like to change the formula so that it will use the value in cell A1
(eg 200) like this:
=COUNTIF(I5:I200;TRUE)/COUNTA(I5:I200)
Thank you in advance.