DColin
asked on
Formula needed
Hi Experts,
I want to know the average absolute values of a range of cells. I have tried =AVERAGE(ABS(A1000:A2000)) but this is not correct.
I want to know the average absolute values of a range of cells. I have tried =AVERAGE(ABS(A1000:A2000))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try
=ABS(AVERAGE(A1000:A2000))
=ABS(AVERAGE(A1000:A2000))
this is an array formula and must be confirmed with CTRL-SHIFT-ENTER. Also, make sure there are no empty cells in the range, otherwise the result will not be correct.
See attached.
cheers, teylyn
27834102.xlsx