| Author |
 Topic  |
|
|
Robbe Degroote
Belgium
5 Posts |
 Posted - 11/29/2024 : 1:59:36 PM
|
Hi
I'm looking for a formula to obtain the average of every 4 cells.
Currently I'm doing it manualy by typing mean(B1:B4) in cell C1, then in cell C5 I type mean(C5:C8), and so on.
I am hoping there is a formula to enter in the F(x) that calculates the average of a cell and the 3 consecutive cells.
Can someone help me? |
|
|
snowli
USA
1390 Posts |
Posted - 11/29/2024 : 10:49:12 PM
|
In F(X) of C, you can enter ave(B, 4) to get the average of every 4 cells.
But it will be put to C1, C2, C3, instead of C1, C5, C9, ....
If you really want results on C1, C5, C9,... only, you can enter the following F(x) of C.
if(mod(i-1,4)==0, Movavg(B,0,3), --)
Thanks, Snow |
 |
|
| |
Topic |
|
|
|
Formula for average of few cells in column