Count cells not between two numbers
To count cell values that are not between two numbers, you can use the COUNTIF function. In the example shown, the formula in cell K5, copied down, is: =COUNTIF(C5:G5,"<"&I5)+COUNTIF(C5:G5,">"&J5) At each new row, this formula returns a count of …Read more