You can also specify several ranges at once.Īs shown in the above formula, a range is defined by two cell addresses separated by a colon. This formula adds all numbers from B3 to B5. An alternative possibility is to click the Sigma ( Sigma) icon next to the input line and enter the range manually. In the field B6, enter the formula =SUM(B3:B5). For example, if you have several items in your A column and want to add them, try the SUM function. A new row is inserted below the current one and can immediately be used for additional input.Įntering formulas in the above way is cumbersome when many cells are involved. For instance, to insert another row between Fuel and Sum, right-click the 5 button to the left and select ‘ Insert Row’ from the context menu. A comprehensive list arranged in categories is available under ‘ Insert’ -> ‘ Function…’. Calc offers many functions beyond the four fundamental arithmetic operations.
0 kommentar(er)
