E
ekskumar
I was trying to sum up a particular range e.g A1: BC1 but in between every
cell contains another formula which calculates the cost, I need to skip these
cells that is every alternate cells and should sum only the cells which
contains a number. Presently am using this formula to get the result =sum
(A1,A3,A5) or =+A5+A3+A5, the problem with the formula is that when we try to
insert a column we need to update the formula as well, would appreciate if
can advice me with any other formula to get the same result.
cell contains another formula which calculates the cost, I need to skip these
cells that is every alternate cells and should sum only the cells which
contains a number. Presently am using this formula to get the result =sum
(A1,A3,A5) or =+A5+A3+A5, the problem with the formula is that when we try to
insert a column we need to update the formula as well, would appreciate if
can advice me with any other formula to get the same result.