| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I created a Formula, OK, but can't get the results in the right ce
Created Formula for G7
=SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the right ce
the answer of G7 in cell G230
the answer of G11 in cell G231, etc In G230: =OFFSET($G$7,ROW(A1)*4-4,) Copy G230 down G230 returns the same as: =G7 G231 returns: = G11 G232 returns: =G15, and so on .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "To Old To . . ." wrote: Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the right ce
One way:
Enter this formula in G230 and copy down as needed: =OFFSET(G$7,(ROWS($1:1)-1)*4,,) Biff "To Old To . . ." wrote in message ... Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the right ce
Or this non-volatile version:
=INDEX(G$7:G$200,1+(ROWS($1:1)-1)*4) Adjust for the end of range Biff "T. Valko" wrote in message ... One way: Enter this formula in G230 and copy down as needed: =OFFSET(G$7,(ROWS($1:1)-1)*4,,) Biff "To Old To . . ." wrote in message ... Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the righ
Thank you for the help, this works . . .
To Old to . . . "Max" wrote: the answer of G7 in cell G230 the answer of G11 in cell G231, etc In G230: =OFFSET($G$7,ROW(A1)*4-4,) Copy G230 down G230 returns the same as: =G7 G231 returns: = G11 G232 returns: =G15, and so on .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "To Old To . . ." wrote: Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the righ
Can you explain the individual parts of this, so that I can beeter understand
how it works? Thank you very much for the help. "Max" wrote: the answer of G7 in cell G230 the answer of G11 in cell G231, etc In G230: =OFFSET($G$7,ROW(A1)*4-4,) Copy G230 down G230 returns the same as: =G7 G231 returns: = G11 G232 returns: =G15, and so on .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "To Old To . . ." wrote: Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the righ
Well, I like that. I understand it a little better. Not as confusing
Thak you for the help "T. Valko" wrote: Or this non-volatile version: =INDEX(G$7:G$200,1+(ROWS($1:1)-1)*4) Adjust for the end of range Biff "T. Valko" wrote in message ... One way: Enter this formula in G230 and copy down as needed: =OFFSET(G$7,(ROWS($1:1)-1)*4,,) Biff "To Old To . . ." wrote in message ... Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the righ
After Googling, I actually understand this. I like your way of doing it.
Thank you . . . "To Old To . . ." wrote: Can you explain the individual parts of this, so that I can beeter understand how it works? Thank you very much for the help. "Max" wrote: the answer of G7 in cell G230 the answer of G11 in cell G231, etc In G230: =OFFSET($G$7,ROW(A1)*4-4,) Copy G230 down G230 returns the same as: =G7 G231 returns: = G11 G232 returns: =G15, and so on .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "To Old To . . ." wrote: Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11 =Sum(G8:G10), etc - This Works Fine Now what I want to do is: the answer of G7 in cell G230 the answer of G11 in cell G231, etc How can I do this. If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11 Thank you for your help. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I created a Formula, OK, but can't get the results in the righ
Glad to hear that. You're welcome.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "To Old To . . ." wrote in message ... After Googling, I actually understand this. I like your way of doing it. Thank you . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding a number created by a formula to a retail price | Excel Worksheet Functions | |||
| I am not able to apply names in already created Vlookup formula. | Excel Worksheet Functions | |||
| Date formatting of formula created dates | Excel Discussion (Misc queries) | |||
| How do I used a big formula I created in Excel? | Excel Worksheet Functions | |||
| Can this formula be created - Challenge | Excel Discussion (Misc queries) | |||
Linear Mode
