Lets say I have some numbers in the range A1:A10 and I have to take a
sum of it in cell B1, I will use the formula =SUM(A1:A10).

My question is, is it possible to detect the last row of the range and
have a dynamic formula?

For instance, the formula should be able to detect A10 (the second
parameter) automatically.

something like =SUM(A1:&count(A:A)) &count(A:A) count will give the
value 10

Sandy