- Creating "Natural-Language" Formulas
- Using the "Intelligent Sum" Button
- Working with Stylist and Autoformat in Calc
- Letting Scenario Manager Help with What-If Projections
- Using and Creating Spreadsheet Themes
- Using DataPilot to Import and Manipulate Information from Databases Created with Other Software
- Mail Merging with OOo Writer Documents and Calc Data
- Summing Up
Using the "Intelligent Sum" Button
Making a "natural-language" formula is fine, especially when you’re working with only one cell, but the Intelligent Sum or Sum button can change a formula for a number of cells at the same time.
For example, if you want to know the total amount of the figures in the Sales column, type "Total Sales" in C15 and change the font to bold 15-point Garamond. Then place the cell pointer on the cell where you want to put the total sales amount. (Changing the font is optional, but it helps your calculation stand out.)
Figure 9.2 The Intelligent Sum button.
Click the Intelligent Sum button. It shows a blue border around the column with the sales values. You can adjust the cell range by using the arrow key. Press Enter.
Figure 9.3 How the Intelligent Sum button works.
You see the Total Sales amount.
Figure 9.4 Total Sales.