Counting the number of the remaining cells (yet to be filled in) of a column

[Michael6]

A column (A1:A60) is being progressively filled in with numbers, and occasionally some blank cells are between. I need a formula to work out the number of the remaining cells (that are yet to be filled in) from the last entry till the last cell (A60) of the column.
Any help will be much appreciated

[oldchippy]

Hi,

You can use a COUNTIF

=COUNTIF(A1:A60,"")

[Michael6]

Thank you Oldchippy. But what is needed is a formula to count the number of the remaining cells [yet to be filled out] from the last entry made till the last cell (A60) of the column.

[martindwilson]

try =60-MATCH(9.999999999E+307,A1:A60,1)

[Palmetto]

Hmmm. . . any reason COUNTBLANK won't work? (as long they're just data entry cells and not formula cells)

=COUNTBLANK(A1:A60)

[martindwilson]

yep coz it will count blanks between numbers not just the last lot!

[Palmetto]

yep coz it will count blanks between numbers not just the last lot!

Oops! Over-looked that bit to count from last entry to end of range.

[Michael6]

Martindwilson, Thank you very much. You gave me the right solution.
The problem is now solved,And I appreciate your help.
And I would like to to thank Palmetto for attempting to help. He too agrees that the formula you suggested is the right one.