I have a spreadsheet in which I have one column of figures, with a second column giving a running average overn7 days, using the average function. I drag the cell with the average formula down on a daily basis to give a new 7 day average. This has worked perfectly. However, it has started returning zero when dragging down. I have made no change to the formula or formatting. The formula has the correct cell references in. I am at a loss as to why this is happening. Any ideas?

The version of Libre office is 7.2.5.2. The OS is Windows 10. The file type it is saved as is .ods

This is a test spreadsheet showing the problem.

Test 1.ods (13.0 KB)

Thanks for your help.