# Countif range is less than or more than another range.

#### Nightcrawller

##### New Member
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.

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### Nightcrawller

##### New Member
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

##### Well-known Member
Try:

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

Last edited:

#### Nightcrawller

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

#### Peter_SSs

##### MrExcel MVP, Moderator
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.

Last edited:

Replies
3
Views
42
Replies
27
Views
215
Replies
16
Views
124
Replies
1
Views
54
Replies
1
Views
36