G
Guest
I need some help in writing a correct formula in excel. I have a formula
that works however part of it is not correct. I am trying to add successive
values from previous cells to the current cell. for example in cell 3 I have
the formula =((B3+B4)/2)+C1+C2, however i wish to keep adding in the
following cells, like the cell below which would be say C4 should be
=((B4+B5)/2)+C1+C2+C3, is there anyway to continue that sum from 1 to the
cell above the current one.
that works however part of it is not correct. I am trying to add successive
values from previous cells to the current cell. for example in cell 3 I have
the formula =((B3+B4)/2)+C1+C2, however i wish to keep adding in the
following cells, like the cell below which would be say C4 should be
=((B4+B5)/2)+C1+C2+C3, is there anyway to continue that sum from 1 to the
cell above the current one.