grifdoogindoggy
New Member
- Joined
- Aug 27, 2019
- Messages
- 21
Hello, I have a table that I want to keep a running average off of based on month. The table looks like this:
<tbody>
</tbody>
I want to keep a running average from January (1) to month of (10). That is to say, once November comes it will update automatically. I thought I could do this with an average if with a logic function built in, but it wasn't working.
Thank you!
Month | Score |
1 | 0.92 |
2 | 0.92 |
3 | 0.89 |
4 | 0.91 |
5 | 0.91 |
6 | 0.81 |
7 | 0.88 |
8 | 0.89 |
9 | 0.83 |
10 | 0.86 |
11 | 0.94 |
12 | 0.93 |
<tbody>
</tbody>
I want to keep a running average from January (1) to month of (10). That is to say, once November comes it will update automatically. I thought I could do this with an average if with a logic function built in, but it wasn't working.
Thank you!
Last edited: