For example: Assume I have 1 Row (A1:K1). All cells are empty, except for two cells, which contain the number "1" (cell C1 and cell E1). I want to count the number of empty cells from E1 until a column of my choice. For sake of the example, let's assume that I choose column number H.

A | B | C | D | E | F | G | H | I | J | K |

1 | 1 | "end column" | ||||||||

<tbody>

</tbody>

The answer in this case needs to be "2".

Note: the last cell with a number, as well as the "end column" will change from time to time. So, the formula needs to change as well. As I wrote in the beginning, I want to count the number of empty cells between my "end-cloumn" and the first non-empty cell.