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

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

=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

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