COUNTIFS practice exercises
Count rows that meet several conditions at once, including a number between two limits.
- 1COUNTIFS with two conditionsIn E2, use COUNTIFS to count the North orders with Sales over 400.
- 2Count between two numbers with COUNTIFSPremiumIn E2, use COUNTIFS to count the people in B2:B8 aged 18 to 30, both ages included. Use the same range twice, once for each limit.
- 3Count the orders between two datesPremiumIn F3, count the orders dated from F1 to F2, both days included. Use the date column twice in COUNTIFS and join each operator to its cell: ">="&F1 and "<="&F2.
- 4COUNTIFS with the conditions in cellsPremiumIn F3, count the reps from the region in F1 with sales of at least the amount in F2. Point at both cells: F1 as it is, and F2 joined to ">=".