There was misprint, use comma , char instead of semicolon ; char:ZVI,
thank you for your response!!
I tried the formula but got an error message.
=IF(MOD(ROW(B1),5),"";AVERAGE(B1:OFFSET(B1,-4,0)))
Do I need to add anything between the ""?
Thank you
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 20:46 | 24 | |||
2 | 06:28 | 89 | |||
3 | 14:57 | 54 | |||
4 | 16:36 | 86 | |||
5 | 09:39 | 60 | 62.6 | ||
6 | 18:10 | 25 | |||
7 | 21:09 | 96 | |||
8 | 12:40 | 41 | |||
9 | 16:20 | 72 | |||
10 | 05:32 | 90 | 64.8 | ||
11 | 10:27 | 32 | |||
12 | 06:08 | 67 | |||
13 | 06:36 | 65 | |||
14 | 13:32 | 42 | |||
15 | 10:43 | 67 | 54.6 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1 | =IF(MOD(ROW(),5)<>0,"",AVERAGE(B1:OFFSET(B1,-4,))) |
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Time | Value | Avg | ||
2 | 20:46 | 24 | |||
3 | 06:28 | 89 | |||
4 | 14:57 | 54 | |||
5 | 16:36 | 86 | |||
6 | 09:39 | 60 | 62.6 | ||
7 | 18:10 | 25 | |||
8 | 21:09 | 96 | |||
9 | 12:40 | 41 | |||
10 | 16:20 | 72 | |||
11 | 05:32 | 90 | 64.8 | ||
12 | 10:27 | 32 | |||
13 | 06:08 | 67 | |||
14 | 06:36 | 65 | |||
15 | 13:32 | 42 | |||
16 | 10:43 | 67 | 54.6 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | =IF(MOD(ROWS(B$2:B2),5)<>0,"",AVERAGE(B2:OFFSET(B2,-4,))) |