excel spreedsheet

  casper69 10:24 25 Jul 06


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 06

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 06

thanks for that it worked perfectly

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009