COUNTIFS practice in Google Sheets
COUNTIFS counts the rows where every condition holds. It takes pairs of range and criterion, in Google Sheets as in Excel, and every range must be the same size.
- 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 ">=".
Functions in this topic
Questions
Can COUNTIFS count between two numbers in Google Sheets?
Yes. Use the same range twice with two criteria, such as =COUNTIFS(B2:B10,">=10",B2:B10,"<=20"), exactly as in Excel.