Forum Discussion

ahoov008's avatar
ahoov008
Copper Contributor
Apr 28, 2026
Solved

COUNTIF Formula

I have an assignment where I have a sheet of student test scores. My sheet contains the students in my class and if they got the answer right or wrong on a 20 question test. I have already averaged o...
  • m_tarler's avatar
    Apr 29, 2026

    looks like you parentheses is off:

    =COUNTIF(V2:V19), ">.895"

    should be

    =COUNTIF(V2:V19 , ">.895" )