19 Feb 2009 at 09:00 #1 Ross Ross Associate Joined 18 Oct 2002 Posts 2,161 Location Here! Hi, I was wondering if anyone knows how to do this: Cell A1 = Sum(a1:a10) Cell A2 = sum(a11:a20) Cell A3 = sum(a21:a30) Is there anyway to drag this down so it fills in the formula automatically? Thanks very much. Ross
Hi, I was wondering if anyone knows how to do this: Cell A1 = Sum(a1:a10) Cell A2 = sum(a11:a20) Cell A3 = sum(a21:a30) Is there anyway to drag this down so it fills in the formula automatically? Thanks very much. Ross
19 Feb 2009 at 11:37 #2 Dolph Dolph Man of Honour Joined 17 Oct 2002 Posts 50,386 Location Plymouth If you set up the 3 and then select all three and drag the series down, it should work.
