Getting the AVERAGE

Posted by: jerome on 12 June 2020, 3:11 am EST

    • Post Options:
    • Link

    Posted 12 June 2020, 3:11 am EST - Updated 3 October 2022, 1:19 am EST

    Hi,

    Can you track what’s wrong with this formula?

    In this image, I am getting the AVERAGE using this formula =AVERAGE(D11:D30) and the answer was correct.

    But, when I used the long method =AVERAGE(D11+D12+D13+D14+D15+D16+D17+D18+D19+D20+D21+D22+D23+D24+D25+D26+D27+D28+D29+D30) with exactly the same data, the result was incorrect.

    Here’s the data:

    Retail Price

    1.25

    1.5

    1.15

    1.05

    1.1

    1.17

    1.4

    1.35

    1.45

    1.45

    1.17

    1.17

    1.29

    1.25

    1.32

    1.3

    1.25

    1.49

    1.38

    1.19

    Was there any issue here getting the AVERAGE with long method or am I doing it the wrong way?

    Hope you can help me.

    Thanks a lot.

  • Posted 14 June 2020, 8:54 pm EST

    Hi,

    For formulas, the inner expression is evaluated first and then outer formula.

    In this case when you pass arguments as A1+A2 then it first performs addition and then calculates the Average. So the effective no of arguments is just 1(the sum of all arguments). If you want to use the Average function with multiple values you should use the syntax like this Average(A1, A2, A3).

    For more information please refer to the following docs:

    https://www.grapecity.com/spreadjs/docs/v13/online/AVERAGE.html

    Regards

  • Posted 15 June 2020, 2:00 am EST

    Hi Sharad,

    Thanks for this info.

    Regards,

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels