For example, to calculate the average sales for a specific product category across multiple regions: Use the SUM function to calculate the total sales meeting the conditions.