Forum Discussion
Solved
AVERAGE function error
So, I have table converted from the website and it´s updating every 16h. I have another sheet where I want to add average value of the defined column from the table. The formula is: =AVERAGE(Tabl...
The values in your screenshot are left-aligned. This makes me suspect that they are text values, not real numbers.
Select the range.
Make sure that the number format is set to General or to Number, not to Text.
On the Data tab of the ribbon, click Text to Columns, then click Finish.
Alternatively, change your average formula to
=AVERAGE(--Table_0[Goals GF/GP])
Your numbers are formatted as text and therefore you get the #DIV/0 error.
=NUMBERVALUE(Tabelle1[@[Goals GF/GP]])In the attached example i entered the above formula in cell F2 and then the formula works in my sheet.