excel spreedsheet

  casper69 10:24 25 Jul 2006


I’m doing a spreadsheet in excel where at the end I’ve made the formula to add a column up to make the total. 2cells along I done exactly the same with the same column so when I change a number both totals will change but when I insert a new row and add a number in, the original total changes correctly but the total 2 cells along doesn’t change automatically is there any way of doing this so it changes when the original total does?

  ArrGee 10:28 25 Jul 2006

If the total figures are exactly the same, and lets say the totals are of figures in column A, use SUM(A:A) in the total cells.

  casper69 10:37 25 Jul 2006

thanks for that it worked perfectly

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?