-
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
Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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
