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

Think about it and look at your formula
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pecoflyer" wrote in message
...

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

When you dragged the cells along the row, Excel may have auto-increment the
values based on what it sees as the pattern you have entered.

HTH,
Bernie
MS Excel MVP

"Pecoflyer" wrote in message
...

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

Trying, but no luck..


--
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

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

Thx for your explanation
I'll have a look at the linear regression thing ( long way back)


--
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