I recently made an excel table to keep track of my weight, and I wanted to add a column for the 7-day moving average.

The issue I'm now having is that when I create a new item, the Moving Average column doesn't automatically fill in. I used this reference to develop the Moving Average formula: Data analysis was available at https://www.deskbright.com/excel/rolling-average-in-excel/.

Here is the moving average formula:

The problem is that when I create a new entry, like this

The Average Weight formula autocompletes, whereas the Moving Average formula does not. The 7-Day Average column's entries for 6/28 and 6/29 in the image are blank. The formula displayed is for the average weight and uses a standard 7-day workweek rather than rolling.

I know it's very easy to fill it out by dragging the formula down, but is there a way to have it autocomplete?

Oct 1, 2022 in Others 784 views

You could use AVERAGEIFS to make the formula auto-fill and COUNTIFS to guarantee that you only return a number if the table contains the correct date range for a 7-day moving average:

`=IF(COUNTIFS(A:A,">="&A2-6,A:A,"<="&A2)<>7,"",AVERAGEIFS(B:B,A:A,">="&A2-6,A:A,"<="&A2))`

• 63,700 points

What does the " @ " symbol mean in Excel formula (outside a table)

Excel has recently introduced a huge feature ...READ MORE

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

Average Every Nth Row All three finish in ...READ MORE

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE