-
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 a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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
