Forum Discussion
Looking for a Function that Counts the Amount of Cells that apply to a certain rule made
I am looking for a function that counts the amount of cells in a column that apply to a conditional rule I made. The cells in the column that apply to the rule are highlighted in a different color, b...
What does the conditional formatting rule look like?
- =ABS((U2 - T2) / T2) > 0.2 is my rule
Let's say the rule applies to cells in rows 2 through 50.
Use the formula
=SUM(--(ABS((U2:U50-T2:T50)/T2:T50)>0.2))
