https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-pleaseI am trying to auto fill a column of formulas by using the fill handle. The first 2 cells contain the formulas:=SUM(Daily!D215:D221)+SUM(Daily!E215:E221)=SUM(Daily!D222:D228)+SUM(Daily!E222:E228)I want each subsequent cell to contain the formula’shttps://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505721271#505721271Ah! thats worked. I was misunderstanding how the original formula you gave me was working.With a bit of tweaking my original formula (=(SUM(Daily!G229:G235)+(SUM(Daily!E229:E235)*-0.03))/2) has become:=((SUM(INDEX(Daily!E:E,P6):INDEX(Daily!E:E,Q6))*-Wed, 24 Aug 2011 07:12:47 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505720813#505720813Hi Gin,Your very first formula ~=SUM(Daily!D215:D221)+SUM(Daily!E215:E221)Is the same as ~=SUM(Daily!D215:E221)Which my index did ~=SUM(INDEX(Daily!D:D,P4):INDEX(Daily!E:E,Q4))Your new formula ~=SUM(Daily!G229:G235)+(SUM(Daily!E229:E235) Written as yWed, 24 Aug 2011 06:54:42 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505719371#505719371Okay, I’m a bit confused again.I’m trying to do a similar thing in an adjacent cell using the same helper rows.The original formula was:=(SUM(Daily!G229:G235)+(SUM(Daily!E229:E235)*-0.03))/2So I tried to change this by following the previous examWed, 24 Aug 2011 05:49:53 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505493767#505493767LoriCheers, I will check that out.CompoundThanks - I had spotted that but thought it was churlish to point out! Thanks again both of you for the help.Fri, 19 Aug 2011 03:45:42 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505473585#505473585Gin good to see you worked out the references.looking back at my post I made an error with this line ~in the second helper column say Cell M1 enter 222 and fill down step 7Should have been ~in the second helper column say Cell M1 enter 221 and fill dThu, 18 Aug 2011 15:40:53 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505468549#505468549This might help a bit.Click the Formulas tab at the top.With this forum page open (so you can see the full formula) click on "Evaluate formula" from the excel menu, near the right hand side.A popup should appear with the formula in. If you click evalThu, 18 Aug 2011 14:12:00 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505468309#505468309Jesus! I thought I was asking something relatively simple! Okay, I had a crack with Lori’s formula and it works! Good stuff, thanks for that. The only problem is if I need to know which cell a particular figure is coming from – I can’t immediatThu, 18 Aug 2011 14:06:36 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505466103#505466103This may be easier to do ~use two helper columns, in the first lets say cell L1 enter 215 and fill down step 7in the second helper column say Cell M1 enter 222 and fill down step 7Now in your first cell this formula and fill down ~=SUM(INDEX(D:D,L1):Thu, 18 Aug 2011 13:20:21 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505465281#505465281*Also, for some reason when copying from the forum it blocks out an extra cell. Hit the funny briefcase icon and use "match destination formatting"Thu, 18 Aug 2011 13:04:22 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28211487/excel-help-please?post_id=505465227#505465227FFSThat actually has to go in A2, I copied the wrong line.Put that lot in A2 and copy to A1, A3 etcThu, 18 Aug 2011 13:03:15 -0500