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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant