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, but I cannot seem to find a function that gives me a "count" of those highlighted cells that align with that rule. I have tried using COUNTIF functions and just typing the equation in that I have as the rule parameter, but is is not working.
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))
