how to add a column if some of the cells are sums of two cells in a row?

Question

how to add a column if some of the cells are sums of two cells in a row?
I want to add Column G.
&nbsp;
&nbsp;

sergeibaklan · Answer

Larry, if you mean your formula in G86, you shall change it from
=SUM(G2:G86)   on
=SUM(G2:G85)
&nbsp;

damien_rosario · Answer

Hi LarryHopefully I am understanding you, if you add in the new column for G, the formulas will change automatically to ensure you are still covering the previous cells.Try inserting a new column for G and then check the formula in cell under Net Profit.CheersDamien

larry fowler · Answer

not add in a column.....but add up (sum) Column G (as shown in the example attached) ...but there are formulas in the column ...rather than actual numbers.....try to add up Column G..

Forum Discussion

how to add a column if some of the cells are sums of two cells in a row?

3 Replies

Resources