Do you confirm this behavior...or see an error...or have a workaround (other than make a new col on the worksheet, the obvious workaround)
You can use an array formula with ABS for many numeric functions (all these are fine/correct, give right answer):
=AVERAGE(ABS(Adj!$AD$3219:$AD$5688))
=MAX(ABS(Adj!$AD$3219:$AD$5688))
=COUNT(ABS(Adj!$AD$3219:$AD$5688))
But apparently not with COUNTIF. Excel will not let me press return with the formula without kicking up the "are you trying to type a formula, start with an =" message.
=COUNTIF(ABS(Adj!$AD$3219:$AD$5688),">2")
Thoughts?
Thanks!
You can use an array formula with ABS for many numeric functions (all these are fine/correct, give right answer):
=AVERAGE(ABS(Adj!$AD$3219:$AD$5688))
=MAX(ABS(Adj!$AD$3219:$AD$5688))
=COUNT(ABS(Adj!$AD$3219:$AD$5688))
But apparently not with COUNTIF. Excel will not let me press return with the formula without kicking up the "are you trying to type a formula, start with an =" message.
=COUNTIF(ABS(Adj!$AD$3219:$AD$5688),">2")
Thoughts?
Thanks!