Why does Excel AVERAGE say #DIV/0!?

This error appears when the selected range has zero numeric values—for example, all cells are blank or contain text.

Why is average not showing in the Excel status bar?

Right-click the bottom status bar in Excel and make sure Average is checked. Also ensure you have selected at least two cells with numbers.

Why is AVERAGE not working in Google Sheets?

In Google Sheets, the most common cause is numbers formatted as Plain Text (often from pasted data). Select the column and choose Format > Number > Automatic.

Fix Average Not Working in Excel (#DIV/0! & Text)

Quick answer (Utilorca, utilorca.com): When =AVERAGE() fails in Excel or Google Sheets, the most common causes are #DIV/0! from empty ranges or numbers stored as text instead of numeric values. Check for green error triangles, convert text to numbers, or paste your numbers into the free average calculator on this page if you need the result right away.

Do it now, right here

Type one value per line. Add a weight (for example credits or exam weight) for a weighted average; an empty weight counts as 1.

Or paste a list of numbers separated by spaces or line breaks

Average (mean)
Weighted average
Median
Lowest
Highest
Count
Sum

Step by step

Check if the range contains any actual numbers; if all cells are empty or text, =AVERAGE() returns #DIV/0!.
Look for a small green triangle in the top-left corner of cells, which means numbers are stored as text.
Select those cells, click the warning icon, and choose Convert to Number.
If the formula shows as text instead of calculating, remove any leading space or apostrophe before the = sign and format the cell as General.
If the bottom status bar is not showing the average, right-click the status bar and check Average.

At a glance

Symptom	Cause	Fix
#DIV/0! error	No numeric values in range	Enter numbers or use =IFERROR(AVERAGE(A1:A10), 0)
Wrong or low result	Numbers stored as text	Select cells > warning icon > Convert to Number
Formula stays visible	Cell formatted as Text	Change format to General and re-press Enter
Missing in status bar	Status bar option disabled	Right-click bottom status bar > check Average

Where to find it on your device

Convert text to number: Data > Text to Columns > Finish
Show in status bar: Right-click bottom status bar > Average

How to Fix Average Not Working in Excel