Hi,
I have Column G 'Release Date Met' which can be populated either Y or N.
I also have Column J 'Number of Incorrect Files Received' which is free text but will be populated with numbers but may be left blank.
I am looking to calculate what percentage of the total responses in Column G are 'Y' and have done this using the formula: =COUNTIF(G4:G985,"Y")/COUNTA(G4:G985)
However, I don't want this percentage to count any data from column G where the same row in column J has a value other than 0.
Is there a way of amending this COUNTIF formula to exclude such values?
I have Column G 'Release Date Met' which can be populated either Y or N.
I also have Column J 'Number of Incorrect Files Received' which is free text but will be populated with numbers but may be left blank.
I am looking to calculate what percentage of the total responses in Column G are 'Y' and have done this using the formula: =COUNTIF(G4:G985,"Y")/COUNTA(G4:G985)
However, I don't want this percentage to count any data from column G where the same row in column J has a value other than 0.
Is there a way of amending this COUNTIF formula to exclude such values?