Nightcrawller
New Member
- Joined
- Sep 1, 2018
- Messages
- 8
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.