Help with spread sheet

  golfpro 10:53 08 Aug 07
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 07

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…