I have a worksheet that I populate dollar values into systematically and then add an average formula to a row of numbers. This row contains some blank cells. After the spreadsheet is generated, the AVERAGE function is considering those blank cells as 0s and thus affecting the average. If after I open the spreadsheet and click the cell with the formula in it and hit enter it then calculates correctly. Please advise on what could be the cause.
Which version are you using? We don’t find this problem. Please try this attached version.