What formula should I use to total the value in column 'Sum of Tot. usage' per week number?
Eg, totals for week 2 is 4221.61
Eg, totals for week 2 is 4221.61
Date | Sum of Tot. usage | Week number |
01/01/2022 | 580.541 | 1 |
02/01/2022 | 469.279 | 2 |
03/01/2022 | 684.628 | 2 |
04/01/2022 | 811.507 | 2 |
05/01/2022 | 386.301 | 2 |
06/01/2022 | 523.257 | 2 |
07/01/2022 | 665.378 | 2 |
08/01/2022 | 681.264 | 2 |
09/01/2022 | 664.35 | 3 |
10/01/2022 | 688.84 | 3 |
11/01/2022 | 937.311 | 3 |
12/01/2022 | 833.83 | 3 |
13/01/2022 | 646.671 | 3 |
14/01/2022 | 644.546 | 3 |
15/01/2022 | 508.209 | 3 |