Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |