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...
The COUNTIF functions is very simple:
=COUNTIF(Range, "Criteria")
by closing the bracket in COUNTIF(V2:V19) - You are completing the function without a criteria.
Hence the correct syntax should be :
=COUNIF(V2:V19,">0.895)
Now in case you want to include multiple conditionS you need to use another variation of the function COUNTIFS with "s'' at the end for multiple condition.
syntax would be =COUNTIFS(Range, "Criteria",Range, "Criteria")