Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to count cells between two values in Excel and Google Sheets
Excel & Google Sheets
=COUNTIFS(B2:B6,">="&50,B2:B6,"<="&100)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Product | Score |
| Alpha | 45 |
| Beta | 72 |
| Gamma | 88 |
| Delta | 55 |
| Epsilon | 110 |
=COUNTIFS(B2:B6,">="&50,B2:B6,"<="&100)→3
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the cell where you want the count to appear.
- 2Type =COUNTIFS( then select the range to evaluate, e.g. B2:B6.
- 3Enter the lower-bound criterion as ">="&50 (or a cell reference like ">="&D1).
- 4Add a comma, repeat the same range, then enter the upper-bound criterion "<="&100.
- 5Close the parenthesis and press Enter.
Tips
- To exclude the boundary values use ">" and "<" instead of ">=" and "<=".
- You can reference cells for the bounds: ">="&D1 makes the formula dynamic.
- COUNTIFS is available in Excel 2007+ and all Google Sheets versions.
- For a strict between (exclusive), swap >= for > and <= for <.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Why does COUNTIFS return 0 when I know values exist in the range?
Check that the numbers are stored as numbers and not text. Select a cell, look at the formula bar — numbers align right by default. Also ensure your criteria strings are correctly quoted.
Can I count between two dates?
Yes. Use the same COUNTIFS pattern but supply dates as criteria, e.g. ">="&DATE(2024,1,1).