How to find the total number of valid cells under a specific cell name

Originally Posted by oeldere

CTRL + H seek => Language.

Seek next (it will find cel C4).

After that you can use this cell in the offered solution.

Hi oeldere, I am required to do this in formula.

Any one can give a bright idea to do this via formula?