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