Definition

• The SumIF function calculates the total aggregate value of all values within a dataset that fall within a specified range, providing a conditional collective performance measure based on minimum and maximum thresholds.

Purpose

• Establishes a filtered team performance metric that sums only the values that fall within defined Min and Max parameters, enabling bonus structures based on performance within acceptable ranges or target bands.

How it works

• Takes all values for a specific KPI or component within the defined scope (typically team level)
• Applies Min and Max parameters to filter which values should be included
• Includes only values that are greater than or equal to Min AND less than or equal to Max
• Calculates the total by adding only the values that meet both criteria
• Returns this conditional sum value to each individual in the group

Input

• Raw performance values (e.g., Sales achievements, target percentages, custom KPI values)
• Min parameter (minimum threshold - values must be ≥ this amount)
• Max parameter (maximum threshold - values must be ≤ this amount)

Output

• The sum of only those values that meet the specified criteria (same conditional total returned for all participants)

Scope

• Applied at the team level - conditional sum is calculated among all positions within the same team for the specific bonus scheme

Use Cases

• Creating bonus pools based only on performance within acceptable target ranges