Cell within a cell?
 

Hiya guys and gals

I have a bit of a problem.

What i need to do is as follows:

in Cells A6 to A60 i have a number
in cell G1 i have a number
and in H2 i have another number

What i need to do is to sum the numbers in collum A from cell number
(whatever number is in G1) and stop at what ever number is in H2

So to clarify in my basic-ish understanding of this is that in need to
do something along the lines of =sum($A'G1')($A'H2)

Obviously i have tried the above and it doesn't work but i'm sure it
can be done.

Any help is very much appreiciated


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=502646

Cell within a cell?
 

can it actually be done, or is this just wishful thinking?


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=502646

Cell within a cell?
 

=sum(indirect("A"&g1&":"&"A"&h2))

is one way.

superkopite wrote:

Hiya guys and gals

I have a bit of a problem.

What i need to do is as follows:

in Cells A6 to A60 i have a number
in cell G1 i have a number
and in H2 i have another number

What i need to do is to sum the numbers in collum A from cell number
(whatever number is in G1) and stop at what ever number is in H2

So to clarify in my basic-ish understanding of this is that in need to
do something along the lines of =sum($A'G1')($A'H2)

Obviously i have tried the above and it doesn't work but i'm sure it
can be done.

Any help is very much appreiciated

--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=502646

--

Dave Peterson

Cell within a cell?
 

Thanks Alot Mate It Works A Treat!!!!!!!


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=502646