How to find SUM when you already have the range?
 

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
D5:D10 =SUM(D5:D10)
D7:D9

Many thanks,

How to find SUM when you already have the range?
 

Try this:

A1 = D5:D10

=SUM(INDIRECT(A1))

--
Biff
Microsoft Excel MVP


"bau" wrote in message
...
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
D5:D10 =SUM(D5:D10)
D7:D9

Many thanks,

How to find SUM when you already have the range?
 

Give this a try...

=SUM(INDIRECT(A2))

--
HTH...

Jim Thomlinson


"bau" wrote:

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
D5:D10 =SUM(D5:D10)
D7:D9

Many thanks,

How to find SUM when you already have the range?
 

It works beautifully.
Thanks!!!

"T. Valko" wrote:

Try this:

A1 = D5:D10

=SUM(INDIRECT(A1))

--
Biff
Microsoft Excel MVP


"bau" wrote in message
...
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
D5:D10 =SUM(D5:D10)
D7:D9

Many thanks,

How to find SUM when you already have the range?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"bau" wrote in message
...
It works beautifully.
Thanks!!!

"T. Valko" wrote:

Try this:

A1 = D5:D10

=SUM(INDIRECT(A1))

--
Biff
Microsoft Excel MVP


"bau" wrote in message
...
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
D5:D10 =SUM(D5:D10)
D7:D9

Many thanks,