Autofil formula always in last rowl

[fulldeen]

Good day.
I am looking for an expession in my formula in order to read the last row and then give the correct range in my formula depending on that row.
i give you an example sheet just to understand.
Thank you in adanced.......

[ragulduy]

Please Login or Register  to view this content.

Alternatively, if it should always be the same row as the cell the formula is placed in:

Please Login or Register  to view this content.

[fulldeen]

That was great.!
Thank you so much.
See you in my next post...