Help! I the formula that would count number of emptys cells in a column based on.....

[MG3]

hello all,

I am looking for the formula that would count the number of empty cells in column G based on the last row of data in column E.

Thanks for your time on this matter,

MG

[ChemistB]

Based how on the last row of data in E?
So if the last row of data in E is in row 200, you want to know how many empty cells are between 1 and 200 in G?

or
if the last row of data in E has the value 56, then you want to know how many empty cells are between 1 and 56 in G?

Try
=COUNTIF(OFFSET($E$1, 0,2, MATCH(9^99, $E:$E),1), "")

[berlan]

Try,

=COUNTBLANK(OFFSET($G$1,0,0,LOOKUP(2,1/($E:$E<>""),ROW($E:$E))))

e.g. if the last non-empy cell in column E is cell E19, this formula will count the blank cells in G1:G19.

[MG3]

Thanks for your time