Forum Discussion
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...
looks like you parentheses is off:
=COUNTIF(V2:V19), ">.895"
should be
=COUNTIF(V2:V19 , ">.895" )
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.