AVERAGEIF

Excel Functions 🇮🇩 Bahasa Indonesia

Dapatkan rata-rata angka yang memenuhi kriteria.

Syntax

EXCEL

=AVERAGEIF(range, criteria, [average_range])

Arguments

Parameter	Deskripsi
`range`	One or more cells, including numbers or names, arrays, or references.
`criteria`	A number, expression, cell reference, or text.
`average_range`	[optional] The cells to average. When omitted, range is used.

Return Value

Angka yang mewakili rata-rata.

Details

Fungsi AVERAGEIF menghitung rata-rata angka dalam rentang yang memenuhi kriteria yang ditentukan. Untuk menerapkan kriteria, fungsi AVERAGEIF mendukung operator logika (>,<,<>,=) dan wildcard (*,?) untuk pencocokan sebagian. AVERAGEIF dapat digunakan untuk membuat rata-rata sel berdasarkan tanggal, angka, dan teks. Perhatikan bahwa AVERAGEIF hanya menangani satu kondisi. Untuk menerapkan beberapa ketentuan, gunakan fungsi AVERAGEIFS. Sintaks umum untuk AVERAGEIF terlihat seperti ini: Fungsi AVERAGEIF mengambil tiga argumen: rentang, kriteria, dan rentang_rata-rata. Rentang adalah rentang sel untuk menerapkan suatu kondisi, dan kriteria adalah kondisi untuk diterapkan, bersama dengan operator logika apa pun yang diperlukan. Argumen rata-rata_range bersifat opsional. Ketika average_range tidak disediakan, AVERAGEIF akan menghitung rata-rata nilai dalam argumen rentang

Contoh

Syntax

The generic syntax for AVERAGEIF looks like this:

EXCEL

=AVERAGEIF(range,criteria,[average_range])

Examples

In the example shown, the formulas in H5:H8 are as follows:

EXCEL

=AVERAGEIF(C5:C15,">0") // price greater than $0
=AVERAGEIF(C5:C15,">200000") // price greater than $200k
=AVERAGEIF(D5:D15,">=2",C5:C15) // 2+ bedrooms
=AVERAGEIF(D5:D15,">=3",C5:C15) // 3+ bedrooms

Double quotes ("") in criteria

In general, text values are enclosed in double quotes (""), and numbers are not. However, when a logical operator is included with a number, the numbe

EXCEL

=AVERAGEIF(D5:D15,2,C5:C15) // 2 bedrooms
=AVERAGEIF(D5:D15,">=2",C5:C15) // 2+ bedrooms

Double quotes ("") in criteria

Double quotes are also used for text values. For example, to average values in B1:B10 when values in A1:A10 equal "red", you can use a formula like th

EXCEL

=AVERAGEIF(A1:A10,"red",B1:B10) // average "red" only

Value from another cell

A value from another cell can be included in criteria using concatenation. In the example below, AVERAGEIF will return the average of numbers in A1:A1

EXCEL

=AVERAGEIF(A1:A10,"<"&B1) // average values less than  B1

Wildcards

The wildcard characters question mark (?), asterisk(), or tilde (~) can be used in criteria. A question mark (?) matches any one character, and an ast

EXCEL

=AVERAGEIF(A1:A10,"*red*",B1:B10) // contains "red"

AVERAGEIF

Syntax

Arguments

Return Value

Details

Contoh

See Also