Hi everyone!
In my degree work I have to calculate hundreds and hundreds average values from saved data sheets. I need help to find out how to calculate average from cells with multiple values divided like this:
example
this is first cell:
3040.3469444444427, 2599.346944444443, 2598.346944444443, 2598.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2871.443333333333
another cell:
<tbody>
</tbody>
Thanks a lot
In my degree work I have to calculate hundreds and hundreds average values from saved data sheets. I need help to find out how to calculate average from cells with multiple values divided like this:
example
this is first cell:
3040.3469444444427, 2599.346944444443, 2598.346944444443, 2598.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2597.346944444443, 2871.443333333333
another cell:
1596.1705555555563, 670.1705555555559, 664.170555555556, 664.170555555556, 664.170555555556, 664.170555555556, 664.170555555556, 663.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 661.170555555556, 662.9608333333338, 662.9608333333338, 662.9608333333338, 662.9608333333338, 662.9608333333338, 664.5997222222226, 664.5997222222226, 665.5997222222226, 667.4416666666671, 669.4416666666671, 673.3469444444448, 677.3469444444447, 685.3469444444447, 711.3469444444446, 1557.4433333333343 |
<tbody>
</tbody>
Thanks a lot