The Klipfolio SUM function calculates the sum of all non-blank values in a range of data and returns the result as a single value.
The syntax for the SUM function is:
SUM( data )
Let's look at a SUM function example.
- Select a component from the Component Tree (Column, Primary Value, etc).
- Click the Start Formula link in the formula editor.
- Click the Insert function button on the formula editing toolbar.
- Select SUM from the Function's menu.
- Click on the Data link in the SUM function.
- Select a value or range of values to include in the SUM.
The values selected are added together to create a sum total.
Examples of the SUM function
The SUM function is useful because it allows you to quickly determine the total for a range of values and can be used in any number of nested formulas. The following examples show different ways you can use a SUM function.
Using a SUM and SLICE function
By using a SLICE function to clean up your data selection you can remove the first value from a column and specify the range you want to include in the equation. If your data source is frequently updated, this method is useful for ensuring that the SUM equation is always using the most current information. For example, selecting an entire column of data means that if additional rows are added to that column, the new values will be automatically included in the equation.
Using a SUM and IF function
The SUM function can work well with an IF function if you want to perform some math in the condition element of the IF formula. This method applies to any math function like an AVERAGE, or MIN/MAX/MEDIAN functions. Note that this example also incorporates a SLICE function (see above) and operators to create a meaningful equation.