AVERAGEFILTERED()

发布于 Nov 19, 2025

1 分钟阅读

This content is currently unavailable in Chinese. You are viewing the default (English) version.

Description

Returns the average of its argument, filtered to completions matching the given condition

Available In

Analysis

Syntax

AVERAGEFILTERED(n: Integer or Number, condition: Boolean)

Example

AVERAGEFILTERED(@Hour of Day, 100 > 20) = 13