-
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
Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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
