Returns the average of all cells that meet multiple criteria.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
AVERAGEIFS(average_range, criteria_range1, criteria1, ...)The AVERAGEIFS function calculates the arithmetic mean of cells that satisfy a set of given conditions. You can specify multiple ranges and corresponding criteria to filter the data before calculating the average.
=AVERAGEIFS(B2:B5, A2:A5, "Sales", C2:C5, ">100")ผลลัพธ์: 150
Calculates the average of values in B2:B5 where column A is 'Sales' and column C is greater than 100.
Yes, you can use the asterisk (*) and question mark (?) as wildcards in text-based criteria.