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 out their percentage on the test. I am to find the percentage of 90's, 80's, 70's, 60's and 50's. When I put the formula in and the rows of data that I want evaluated, I get an error message that says "you have entered too few arguments for this function. Here is what my formula looks like:
=COUNTIF(V2:V19), ">.895"
Can anyone tell me what I am doing wrong?
3 Replies
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")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")looks like you parentheses is off:
=COUNTIF(V2:V19), ">.895"
should be
=COUNTIF(V2:V19 , ">.895" )
