Excel Formula Average #div0. To divide two numbers in Excel you type the equals sign in a cell then type the number to be divided followed by a forward slash followed by the number to divide by and press the Enter key to calculate the formula. UNDERSTAND FIX EXCEL ERRORS.
In the cells it is calculating it gives value. AVERAGEIF will automatically ignore empty cells even when criteria match. Error if the range of supplied to SUM function has at least one DIV0.
The AVERAGE function returns the error of DIV0.
Which basically multiplies the monthly value by 12 and divides it to find out the daily average for the year or the yearly average. Because it is trying to divide what it thinks are letters not numbers. Text sits on the. So we can estimate this formula with the IFERROR function to avoid the DIV0.