How to find SUM when you already have the range?

[Guest]

Hi all,
I have a situation where column A has different range value, I would like
to find the sum for the indicated range in the colum A. What should I write
in colum B (say in cell B2) instead of typing of "=SUM(" then drag cell D5
through D10?

Column A Column B
Range Total
D510 =SUM(D510)
D79

Many thanks,

 

[T. Valko]

Try this:

A1 = D510

=SUM(INDIRECT(A1))

 

[Guest]

Give this a try...

=SUM(INDIRECT(A2))

 

[Guest]

It works beautifully.
Thanks!!!

Try this:

A1 = D510

=SUM(INDIRECT(A1))

 

[T. Valko]

You're welcome. Thanks for the feedback!