AVERAGEIFS Calculation Example . Assume you're tracking sales data for different products in various cities. The cities are in cells A2:A6, the products in cells B2:B6, the number of products sold ...