Dynamic formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sandip.dhamapurkar@gmail.com - 21 Jun 2006 12:55 GMT

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

Reply to this Message

Bob Phillips - 21 Jun 2006 13:08 GMT

Why not just use

=SUM(A:A)

Signature

HTH

Bob Phillips

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

> 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).
[quoted text clipped - 9 lines]
>
> Sandy

Reply to this Message

aidan.heritage@virgin.net - 21 Jun 2006 13:58 GMT

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?!

> Why not just use
>
[quoted text clipped - 20 lines]
> >
> > Sandy

Reply to this Message

sandip.dhamapurkar@gmail.com - 21 Jun 2006 14:03 GMT

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

Reply to this Message