Search code examples
google-sheetsaverage

Google sheet average function results the wrong average value

I am trying the average function to calculate the average of the number in column, but it gives the wrong result. All are numbers, I have also checked by applying ISNUMER() function.

below is the screenshot

Average function result

Actual average value of A1 to A3 should be 60074.67, but average function gives different result.

What is wrong in my function?

Solution

  • Seems like you are only calculating the average of cells A1 and A3. For the whole range try

    =AVERAGE(A1:A3)

    and see if that helps?