Spread sheet help wanted

  golfpro 07:34 30 Aug 2007
Locked

I am using Open Office Calc, on one sheet I have a load of numbers in one column "F", in which I make frequent alterations. I would like to place a total number somewhere that updates automatically when I make a change. How do I do this?

  Belatucadrus 09:52 30 Aug 2007

Two ways either select a cell under the column and click the "sum" button its the one showing the Greek Sigma S or manually enter =SUM(F5:F24) into a cell of your choice.
F5 and F24 are just examples, adjust to whatever range of cells your column fills.

  VoG II 10:06 30 Aug 2007

If Calc is anything like Excel you could also use

=SUM(F:F)

which will sum the whole of column F, ignoring any headings etc. and will correctly sum as the number of rows in column F changes.

This formula must be placed in a column other than F.

  golfpro 11:03 30 Aug 2007

Thanks Belatucadrus this worked fine.

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

HomePod review

Comment regarder les Oscars 2018 ?