Count cells between two values in a column

Formula in D15:

=ABS(MATCH(C12, tbl, 0)-MATCH(C13, tbl, 0))-1 + ENTER

Named ranges

tbl (A1:A10)

Count cells between two values in a row

Formula in D23:

=ABS(MATCH(C20, tbl_row, 0)-MATCH(C21, tbl_row, 0))-1 + ENTER

Named ranges

tbl_row (A18:E18)

Download excel sample file for this tutorial.

formula to count cells between two values.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

MATCH(lookup_value;lookup_array; [match_type])
Returns the relative position of an item in an array that matches a specified value

ABS(number)
Returns the absolute value of a number, a number without its sign.

Related posts:

1. Count number of times a string exist in multiple cells using excel formula
2. Count unique distinct values in three columns combined in excel
3. Count duplicate distinct values in a column in excel
4. Count unique distinct values in two columns in excel
5. Count unique distinct values in a column in excel
6. Count unique values and unique distinct values in two ranges combined
7. Count unique distinct values in two columns with date criteria in excel
8. Count unique values and unique distinct values in three ranges combined in excel
9. Sorting numbers and text cells also removing blanks using array formula in excel
10. Sorting text cells using array formula in excel