Syntax
GROUPSUM(<number>)
Description
...
| Groups | Participants_SUM |
|---|---|
| group1 | 34 |
| group2 | 244 |
| group3 | <error> |
Additional Information
...
Replicate the
...
SUMIF Function
The SUMIF function can be accomplished by combining the two separate functions GROUPSUM and IF.
Example
Given the following data:
| Key | Value |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 2 |
| 2 | 3 |
first create groups that contain the values you want to sum. This example excludes values less than 2 from the total sum.
| No Format |
|---|
GROUPSUM( IF( (#Data!Value >= 2); #Data!Value; 0) ) |
The result of this formula executes the GROUPSUM function with the specified conditional statement. Both the groups had a value that was 1. This value was changed to 0 as specified in the IF statement. The new sum of the groups in this example are displayed in the Total_Value1 column.
| Key | Total_Value | Total_Value1 |
|---|---|---|
| 1 | 3 | 2 |
| 2 | 6 | 5 |