Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Syntax

GROUPSUM(<number>)

Description

Adds its arguments.

...

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.

KeyTotal_ValueTotal_Value1
132
265

...