Definition

• The AverageIF function calculates the arithmetic mean of all values within a dataset that fall within a specified range, providing a conditional average performance measure based on minimum and maximum thresholds.

Purpose

• Establishes a filtered team performance benchmark that averages only the values that fall within defined Min and Max parameters, enabling bonus structures based on typical 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 average by summing the qualifying values and dividing by the count of qualifying values
• Returns this conditional average 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 average of only those values that fall within the specified Min-Max range (same conditional average returned for all participants)

Scope

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

Use Cases

• Creating performance benchmarks based only on achievements within acceptable target ranges