Cell within a cell?

S

superkopite

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
 
D

Dave Peterson

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

is one way.
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
Click to expand...
 
Top