software

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: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=502646
can it actually be done, or is this just wishful thinking?--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=502646=sum(indirect(quot;Aquot;amp;g1amp;quot;:quot;amp;quot;Aquot;amp;h2))

is one way.

superkopite wrote:
gt;
gt; Hiya guys and gals
gt;
gt; I have a bit of a problem.
gt;
gt; What i need to do is as follows:
gt;
gt; in Cells A6 to A60 i have a number
gt; in cell G1 i have a number
gt; and in H2 i have another number
gt;
gt; What i need to do is to sum the numbers in collum A from cell number
gt; (whatever number is in G1) and stop at what ever number is in H2
gt;
gt; So to clarify in my basic-ish understanding of this is that in need to
gt; do something along the lines of =sum($A'G1')($A'H2)
gt;
gt; Obviously i have tried the above and it doesn't work but i'm sure it
gt; can be done.
gt;
gt; Any help is very much appreiciated
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=502646

--

Dave Peterson


Thanks Alot Mate It Works A Treat!!!!!!!--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=502646