Count cells between two values in a column
Formula in D15:
Count cells between two values in a row
Formula in D23:
Download excel sample file for this tutorial.
formula to count cells between two values.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
Returns the relative position of an item in an array that matches a specified value
Returns the absolute value of a number, a number without its sign.