I am unable to get this exspression to work. It appears
to me that the abs function will only operate for one
value, I need it to apply to a range of values.
If you do it right, then Excel will show the formula in the formula bar as
{=AVERAGE(ABS(A1:A10))}
to indicate that it has been interpreted as an array formula. Note that
you do not type the curly brackets; Excel adds them automatically when
you have correctly communicated (by array entering) to Excel that it is
an array formula.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
