Help with spread sheet

  golfpro 10:53 08 Aug 2007
Locked

I don't have excel but use open office, however the calc spread sheet is the same.
In one of the sheets I have six columns across (A to F), and I keep adding to the down columns (1 to 20). The last column across (F) is a number of items. This changes as I modify the number of items within 1 to 20. I would like to have a total of all the items in F, somewhere on the sheet, which auto calculates all the changes. How do I do this.
I see there is in tools an auto calc feature but I don't know how to use it.

  VoG II 10:58 08 Aug 2007

In Excel you could use

=SUM(F:F)

but I don't know whether this would work in Open Office.

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017