AVERAGEFILTERED()

公開日 Nov 19, 2025

1 分で読めます

This content is currently unavailable in Ja - 日本語. 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