Executing a formula based on an IF statement

  • Hello,
    I am trying to calculate the % complete (non-blank cells) in the range I76:J106. However, I only want to count the cells in that range if A76:A106="Pre".


    I can calculate the % complete of the total range with =(COUNTIF(I76:J106,"<>"))/(ROWS(I76:I106))), field formatted as a percentage. However, I cannot figure out how to layer in the condition to only calculate rows that have "Pre" in column A.


    I tried =IF(A76:J106,"Pre",((COUNTIF(I76:J106,"<>"))/(ROWS(I76:I106)))) but I got a #VALUE error.


    Can anyone help? Thank you in advance!