Forum Discussion
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...
COUNTIF requires two arguments inside the parentheses:
COUNTIF(range, criteria)
Issues:
- You closed the parenthesis too early
- The criteria must be inside the same parentheses as the range
Correct Formula:
=COUNTIF(V2:V19, ">=0.895")