How do you count the number of cells between two particular cells in excel?

Answer 1

This may be too simplistic, but the number of columns between two cells can be counted as follows:

num_cols = CELL("col") - CELL("col",A1)

that would give you the number of columns between the current cell and column A.

for a row count, you could switch the "info_type" parameter to "row" (1st parameter)

num_rows = CELL("row") - CELL("row",A1)

the number of rows between the current cell and A1.

by combining them both you can obtain the number of cells in between. Keep in mind that if the current cell is before the target cell, the number will be negative (thus the addition of the absolute function).

numcells = (abs(num_rows) +1) * (abs(num_cols)+1) - 2

this math assumes you are using two distinct cells and not the same cell, otherwise the result would be -1.