Dynamic formula

[sandip.dhamapurkar]

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

 

[Bob Phillips]

Why not just use

=SUM(A:A)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[aidan.heritage]

providing you don't have blanks then

=SUM(a1:OFFSET(a1,COUNTA(a:a)-1,0))

will give you the dynamic you want - but as Bob says, why not just use
the entire column?!

 

[sandip.dhamapurkar]

Thank you both of you for your answers. I really appreciate