Although they look like numbers but they are not.

Why is my average formula not working in excel. For example on the left-hand side you can see Customer ID looks similar to numbers. You can see from my screenshot that I had selected multiple cells but it is only showing me the Count though I had asked for Average and Sum as well. Perhaps those numbers are text formatted in which case AVERAGE not finding any true numbers will return DIV0.

AVERAGE E30J30 Where there is a will there are many ways. Try converting like this. 6 Main Reasons for Excel Formula Not Working with Solution Reason 1 Cells Formatted as Text.

Then you forgot to add to your text for finding. IF E2W H20IF I2I20 0 will convert a text-formatted number to an actual number then your AVERAGE function should work. Share the link from where I can download your Excel workbook.

In Excel I have multiple tabs open with similar data. Jump into the affected. If your data includes text values Excels AVERAGE function wont give you an accurate picture.

The most common reason for an Excel formula not calculating is that you have inadvertently activated the Show Formulas mode in a worksheet. Reason 3 Values are Different Result is Different. Show Formulas enabled - just click to disable The reason Show Formulas can be accidentally enabled is because it has the keyboard shortcut Control that a user might unknowingly type.

This will bring up a menu with three choices. Please also mark the thread as Solved once it is solved. If you are happy with the results please add to the contributors reputation by clicking the reputation icon star icon below left corner.