.. compute the number of cell from A6 to A1 in order to arrive 7

Generally, you could use
=COUNTA(A:A)
to count the above

Or, simply adjust the expression
with an arithmetic addition/subtraction like this eg:
=COUNTA(A:A)+1
=COUNTA(A:A)-1
if you want a number one greater/less than
the number of filled cells in the range for whatever purpose

The above expressions could be used within say, an OFFSET
as the height param to function as a dynamic range
(this assumes cells filled continuously from row1 down in col A)

I don't know what you're trying to do. Perhaps better for you to post afresh
as a new thread, and explain clearly your underlying intents from scratch.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---