Something odd, that's for sure.
The cell references inside the formula changed when we copied the cell down a row. In fact, if you'll notice, the formula changed so it will work on the new row the same way it worked on the old row.
Useful, that. What happens if we copy it down to the next row?
|
A | B | C | D |
| 1 | Salespeople And Units Sold | |||
| 2 | ||||
| 3 | Person | Cars | Trucks | Total |
| 4 | Bill | 6 | 11 | =B4+C4 |
| 5 | Mike | 11 | 19 | =B5+C5 |
| 6 | Molly | 6 | 13 | =B6+C6 |
|
Excellent. Just what we wanted.
Just for kicks, even though it won't help our spreadsheet, what happens if we move it over a column?
|
A | B | C | D | E |
| 1 | Salespeople And Units Sold | ||||
| 2 | |||||
| 3 | Person | Cars | Trucks | Total | |
| 4 | Bill | 6 | 11 | =B4+C4 | =C4+D4 |
| 5 | Mike | 11 | 19 | =B5+C5 | |
| 6 | Molly | 6 | 13 | =B5+C5 | |
|
Hmmmm. Well, that's not good for much, but the pattern remains: we copied it over one column, and the cell references changed so all their columns went up by one.