Share via

Excel 2011: absolute average formula

Anonymous
2012-03-25T04:32:56+00:00

Hi, I am using Microsoft Excel 2011 for Mac with OS 10 and I want to know the formula for the absolute average of a column of cells.  Ive tried abs(AVERAGE(a1:A10)) but this does not work. 

Any help will be appreciated.

Marc

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2012-03-25T19:03:38+00:00

    Bob's exactly right that you don't provide enough information to do more than guess. "Absolute Average" isn't a term that has a common definition.

    And posting  "does not work" without explaining what "does work" means to you, is asking to have your mind read.

    However, as a guess, if you mean to average the absolute values of each cell in the range, then array-entering this

    =AVERAGE(ABS(A1:A10))

    using CMD-RETURN rather than just RETURN should work. You can find out more about array formulae in Excel Help.

    10+ people found this answer helpful.
    0 comments

12 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-06-24T16:16:08+00:00

    If you are working with an Array, use:  =AVERAGE(ABS(a1:a10)) and hit CTRL-SHIFT+ENTER

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-03-25T16:12:22+00:00

    Phil, you really need to stop throwing in suggestions that don't help, and illustrate that you do not understand the problem. Switching from relative to absolute has no bearing on this problem.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2012-03-25T16:15:36+00:00

    First, you need to explain what you mean by absolute average. Then you need to explain why abs(AVERAGE(a1:A10)), does not work, and what "does not work" means. Do you get an error? The wrong answer? Why do you think it is wrong? etc. We need to understand what you are trying to do in order to give you an accurate answer.

    0 comments
  4. Anonymous
    2012-03-25T13:01:29+00:00

    See This:http://www.screencast.com/t/zJV65XN40

    Try using $A$1:$A$10 would that work

    0 comments