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 <.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
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).