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.