Count one product

Intermediate← PreviousSkip →
Exercise 2 of 11COUNTIF

How many orders were for Laptops?

Write your formula in the green cell, I2.

Conditional math

Revenue for one regionCount one productRevenue for one repOrders over $1,000Two conditions at onceCOUNTIFS with a numberAverage for one repWildcardsSmallest matching valueRevenue for one monthAVERAGEIFS
q1-orders.xlsx
fx
1DateRegionRepProductUnitsRevenue
2Jan 4, 2026NorthAvaLaptop3$3,600.00Laptop orders
3Jan 9, 2026SouthLeoMonitor5$1,250.00
4Jan 15, 2026NorthMayaLaptop2$2,400.00
5Jan 22, 2026EastSamKeyboard12$720.00
6Feb 3, 2026WestZoeMonitor4$1,000.00
7Feb 11, 2026NorthAvaKeyboard8$480.00
8Feb 19, 2026SouthIvyLaptop4$4,800.00
9Feb 27, 2026EastSamMonitor6$1,500.00
10Mar 6, 2026WestNoahLaptop1$1,200.00
11Mar 14, 2026NorthMayaMonitor7$1,750.00
12
13

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

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. 1.Revenue for one region
  2. 2.Count one product
  3. 3.Revenue for one repPremium
  4. 4.Orders over $1,000Premium
  5. 5.Two conditions at oncePremium
  6. 6.COUNTIFS with a numberPremium
  7. 7.Average for one repPremium
  8. 8.WildcardsPremium
  9. 9.Smallest matching valuePremium
  10. 10.Revenue for one monthPremium
  11. 11.AVERAGEIFSPremium
See the whole topic →