COUNTIFS with a number
Exercise 6 of 11 Premium
How many Laptop orders had 3 or more units?
Checking your plan…
q1-orders.xlsx
ABCDEF
1DateRegionRepProductUnitsRevenue
2
3
4
5
6
7
8
About conditional math in Excel
SUMIF, COUNTIF and SUMIFS are behind almost every report: total sales for one region, the number of orders over $1,000, revenue for one product in one region. These exercises use a real orders table so you can see exactly which rows match.
GuideHow to Use COUNTIF in Excel (and COUNTIFS)→Functions you can use here
SUMIF(range, criteria, [sum_range])COUNTIF(range, criteria)SUMIFS(sum_range, criteria_range1, criteria1, …)AVERAGEIF(range, criteria, [average_range])
More conditional math exercises
- 1.Revenue for one region
- 2.Count one product
- 3.Revenue for one repPremium
- 4.Orders over $1,000Premium
- 5.Two conditions at oncePremium
- 6.COUNTIFS with a numberPremium
- 7.Average for one repPremium
- 8.WildcardsPremium
- 9.Smallest matching valuePremium
- 10.Revenue for one monthPremium
- 11.AVERAGEIFSPremium