-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Countif and absolute values
- Thread starter sscornav
- Start date
Excel Facts
Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
What if one needs to do a count with a formula in the condition, like this:
=countif( range, abs(xxx-norm_value)<0.01)
or perhaps;
=SUMPRODUCT( --(ABS((range)-test_Value)<0.01))
i.e. in the formula, one needs to reference the values in the range.
=countif( range, abs(xxx-norm_value)<0.01)
or perhaps;
=SUMPRODUCT( --(ABS((range)-test_Value)<0.01))
i.e. in the formula, one needs to reference the values in the range.
Last edited:
Upvote
0
