AVERAGEIF and AVERAGEIFS practice exercises
Take the average of only the rows that meet one condition, or several with AVERAGEIFS, and leave zeros out of an average.
- 1Average one group with AVERAGEIFIn D2, use AVERAGEIF to find the average order value of the Online orders.
- 2Average with two conditions with AVERAGEIFSPremiumIn F1, find the average sale of Shoes in the North region. AVERAGEIFS starts with the range to average, then each range with its condition.
- 3Leave zeros out of an averagePremiumThe store is closed on Mondays and Sundays and records 0 sales. In E1, find the average sales of the days it was open: AVERAGEIF with the condition ">0".