I changed your question when I asked AI this time to:I have a column of numbers IN EXCEL that I want to keep a running average of. I know how to keep a running sum, however I don’t know how what formula I need to keep a running average.

Now I received this answer:

Here's how to calculate a running average in Excel:

**Understanding Running Averages**

A running average (also called a cumulative average) is the average of all the numbers in a sequence up to a given point. So, the first running average is just the first number itself. The second running average is the average of the first two numbers, and so on.

**Formula**

Assuming your data starts in cell A1, here's the formula you would put in cell B1 and then copy down:

*   **Cell B1:** `=AVERAGE(A$1:A1)`

**Explanation**

*   `AVERAGE(A$1:A1)`: This calculates the average of the range of cells starting from A1 and ending at A1.
*   `A$1`: The dollar sign before the '1' makes this an absolute reference to row 1. This part of the range will always start at the first cell (A1).
*   `A1`:  This is a relative reference.  When you copy the formula down, this part will change (A2, A3, A4, etc.), expanding the range being averaged.

**How it Works When You Copy Down**

*   **Cell B2:** When you copy the formula from B1 to B2, the formula becomes `=AVERAGE(A$1:A2)`. This calculates the average of cells A1 and A2.
*   **Cell B3:**  In B3, the formula becomes `=AVERAGE(A$1:A3)`.  This calculates the average of cells A1, A2, and A3.
*   And so on...

**Example**

Let's say your column A has the following numbers:

| Column A (Data) | Column B (Running Average) | Formula in Column B |
|---|---|---|
| 10 | 10 | `=AVERAGE(A$1:A1)` |
| 20 | 15 | `=AVERAGE(A$1:A2)` |
| 30 | 20 | `=AVERAGE(A$1:A3)` |
| 40 | 25 | `=AVERAGE(A$1:A4)` |
| 50 | 30 | `=AVERAGE(A$1:A5)` |

**Steps**

1.  **Enter your data:** Put your numbers in column A, starting at cell A1.
2.  **Enter the formula:** In cell B1, type `=AVERAGE(A$1:A1)` and press Enter.
3.  **Copy the formula down:** Click on cell B1.  You'll see a small square at the bottom-right corner of the cell (the fill handle).  Click and drag this fill handle down to the last row of your data in column A.  Excel will automatically adjust the formula for each row, calculating the running average.

That's it! You should now have a column showing the running average for your data.