Hello I want the average of the current last 3 month on my spreadsheet. .Below is a copy of what my spreadsheet looks like it show the average for Dec, Jan & Feb (which I just keyed in) Next month I would want the average for Jan, Feb & Mar. etc
I found this formula but it just does not do it. Average(Offset( C2,0,Count(C2:P2)-3,1,3)).
Thanks for taking the time to help
L
I found this formula but it just does not do it. Average(Offset( C2,0,Count(C2:P2)-3,1,3)).
11/01/20 | 12/01/20 | 01/01/21 | 02/01/21 | 03/01/21 | 04/01/21 | 05/01/21 | 06/01/21 | 07/01/21 | 08/01/21 | 09/01/21 | 10/01/21 | 11/01/21 | 12/01/21 | Average |
10 | 20 | 30 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 |
Thanks for taking the time to help
L