Hi,

Further clarification, if necessary:

You have 3 cells with number and the fourth cell sums those three numbers.
Now you drag to the right and Excel figures you want to copy what is in those
cells to corresponding positions. So E1 is a copy of A1, F1 is a copy of B1,
G1 is a copy of C1 and H1 is a copy of D1. A1:C1 have random numbers so
E1:G1 have random numbers (or Excel's linear regression calculation of those
numbers) and H1 has a copy of D1 which is a relative formula saying sum the
three cells to the left. E1:G1.


--
Thanks,
Shane Devenshire


"Pecoflyer" wrote:


I entered three random values in a1-c1 and summed them up in D1
hen, selected A1-D1 and dragged along the row.
H1 does give the sum of E1-G1, but where do these cells get there
values?


+-------------------------------------------------------------------+
|Filename: Funny.xlsx |
|Download: http://www.thecodecage.com/attachmen...attachmentid=3 |
+-------------------------------------------------------------------+

--
Pecoflyer
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24206