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.