Countif range is less than or more than another range.

[Nightcrawller]

I want to count if a range of cells are less than or more than another range of cells.=countif(K12:K491, "<1.9") =countif(J12:J491, "<1.9")this is what i am using now but i want this:=countif(J14:J493<K14:K493) but its a formula phrase error.

 

[Nightcrawller]

I want to count if a range of cells are less than or more than another range of cells.=countif(K12:K491, "<1.9") =countif(J12:J491, "<1.9")this is what i am using now but i want this:=countif(J14:J493<K14:K493) but its a formula phrase error.I am sorry i am using mobile browser and i swear i have well presented the whole thread but it just messes up.

 

[steve the fish]

Try:

=SUMPRODUCT(--(J14:J493 < K14:K493))<k14:k493))< html=""></k14:k493))<>

 

[Nightcrawller]

Thanks bro but can you tell me the point of having this (--) extra encasing bracket?

 

[Peter_SSs]

Thanks bro but can you tell me the point of having this (--) extra encasing bracket?

SUMPRODUCT requires numbers to work with.
J14:J493 < K14:K493 produces an array of TRUE/FALSE logical values
--( ) forces those TRUE/FALSE values to 1/0 values so SUMPRODUCT can add them.