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

Dell XPS 13 9370 (2018) review

Creative studio Omnibus' brand identity for We Said Enough fights back against sexual misconduct

WWDC history: Apple's product launches since 2005

Espace de stockage : comment libérer de la mémoire sur votre iPhone ?