Syntax
GROUPSUM(<number>)
Description
Adds its arguments.
...
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 |