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.