View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
To Old To . . . To Old To . . . is offline
external usenet poster
 
Posts: 8
Default 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.