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?
looks like you parentheses is off:
=COUNTIF(V2:V19), ">.895"
should be
=COUNTIF(V2:V19 , ">.895" )
5 Replies
Alternative solution proposals…
using your range V2:V19
=COUNTIFS(V2:V19, ">0.895", V2:V19, "<1.5", V2:V19, "<>0.9", V2:V19, "<>"&AVERAGE(V2:V19))
OR
Most Powerful / Flexible…
=SUMPRODUCT(
(V2:V19 > 0.895) *
(V2:V19 < 1.5) *
(MOD(ROW(V2:V19), 2) = 0) *
(ISNUMBER(V2:V19)) *
(LEFT(CELL("address", V2:V19), 1) = "$V$") *
(V2:V19 <> AVERAGE(V2:V19)))
Including mixed criteria types (text, wildcards, other ranges, errors, ormod logic), with COUNTIFS + SUMPRODUCT.
My answers are voluntary and without guarantee!
Hope this will help you.
Thank you so much to everyone who replied!! I appreciate your help so much!! Y'all saved the day!
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" )
