From the choices listed below,which function determines the number of times the word "YES" appears in a range of cells?
A) =COUNT(G7:G12,"YES")
B) =COUNTIF(G7:G12,"YES")
C) =COUNTA(G7:G12,"YES")
D) =SUMIF(G7:G12,"YES")

Question

Quizplus · Accepted Answer

The function =COUNTIF(range, criteria) is used to count the number of cells within a specified range that meet a given criteria. In this case, the criteria is "YES" and the range is G7:G12, so the function becomes =COUNTIF(G7:G12,"YES"). This will count the number of cells in the range containing "YES".

From the Choices Listed Below,which Function Determines the Number of Times